Dataset statistics
| Number of variables | 39 |
|---|---|
| Number of observations | 118315 |
| Missing cells | 182649 |
| Missing cells (%) | 4.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 208.8 MiB |
| Average record size in memory | 1.8 KiB |
Variable types
| Categorical | 24 |
|---|---|
| Numeric | 15 |
order_id has a high cardinality: 98665 distinct values | High cardinality |
product_id has a high cardinality: 32951 distinct values | High cardinality |
seller_id has a high cardinality: 3095 distinct values | High cardinality |
shipping_limit_date has a high cardinality: 93317 distinct values | High cardinality |
product_category_name has a high cardinality: 73 distinct values | High cardinality |
seller_city has a high cardinality: 611 distinct values | High cardinality |
review_id has a high cardinality: 98452 distinct values | High cardinality |
review_comment_title has a high cardinality: 4569 distinct values | High cardinality |
review_comment_message has a high cardinality: 36434 distinct values | High cardinality |
review_creation_date has a high cardinality: 633 distinct values | High cardinality |
review_answer_timestamp has a high cardinality: 98290 distinct values | High cardinality |
customer_id has a high cardinality: 98665 distinct values | High cardinality |
order_purchase_timestamp has a high cardinality: 98111 distinct values | High cardinality |
order_approved_at has a high cardinality: 90173 distinct values | High cardinality |
order_delivered_carrier_date has a high cardinality: 81016 distinct values | High cardinality |
order_delivered_customer_date has a high cardinality: 95663 distinct values | High cardinality |
order_estimated_delivery_date has a high cardinality: 449 distinct values | High cardinality |
customer_unique_id has a high cardinality: 95419 distinct values | High cardinality |
customer_city has a high cardinality: 4110 distinct values | High cardinality |
price is highly correlated with payment_value | High correlation |
freight_value is highly correlated with product_weight_g | High correlation |
payment_value is highly correlated with price | High correlation |
product_weight_g is highly correlated with freight_value and 2 other fields | High correlation |
product_length_cm is highly correlated with product_width_cm | High correlation |
product_height_cm is highly correlated with product_weight_g | High correlation |
product_width_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
price is highly correlated with payment_value and 1 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
product_weight_g is highly correlated with price and 3 other fields | High correlation |
product_length_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly correlated with product_weight_g | High correlation |
product_width_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
order_item_id is highly correlated with payment_sequential | High correlation |
price is highly correlated with payment_sequential and 1 other fields | High correlation |
freight_value is highly correlated with payment_sequential | High correlation |
payment_sequential is highly correlated with order_item_id and 2 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
product_height_cm is highly correlated with product_category_name | High correlation |
product_description_lenght is highly correlated with product_category_name | High correlation |
price is highly correlated with payment_value | High correlation |
customer_state is highly correlated with customer_zip_code_prefix | High correlation |
product_length_cm is highly correlated with product_width_cm and 1 other fields | High correlation |
product_weight_g is highly correlated with product_category_name | High correlation |
product_width_cm is highly correlated with product_length_cm and 1 other fields | High correlation |
seller_state is highly correlated with seller_zip_code_prefix and 1 other fields | High correlation |
customer_zip_code_prefix is highly correlated with customer_state | High correlation |
seller_zip_code_prefix is highly correlated with seller_state and 1 other fields | High correlation |
product_category_name is highly correlated with product_height_cm and 6 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
product_category_name has 1709 (1.4%) missing values | Missing |
product_name_lenght has 1709 (1.4%) missing values | Missing |
product_description_lenght has 1709 (1.4%) missing values | Missing |
product_photos_qty has 1709 (1.4%) missing values | Missing |
review_comment_title has 104226 (88.1%) missing values | Missing |
review_comment_message has 67650 (57.2%) missing values | Missing |
order_delivered_carrier_date has 1254 (1.1%) missing values | Missing |
order_delivered_customer_date has 2588 (2.2%) missing values | Missing |
order_id is uniformly distributed | Uniform |
shipping_limit_date is uniformly distributed | Uniform |
review_id is uniformly distributed | Uniform |
review_answer_timestamp is uniformly distributed | Uniform |
customer_id is uniformly distributed | Uniform |
order_purchase_timestamp is uniformly distributed | Uniform |
order_approved_at is uniformly distributed | Uniform |
order_delivered_customer_date is uniformly distributed | Uniform |
customer_unique_id is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2021-08-09 19:56:27.245288 |
|---|---|
| Analysis finished | 2021-08-09 21:15:56.937797 |
| Duration | 1 hour, 19 minutes and 29.69 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 98665 |
|---|---|
| Distinct (%) | 83.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 |
|---|---|
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 |
| ccf804e764ed5650cd8759557269dc13 | 26 |
| 6d58638e32674bebee793a47ac4cbadc | 24 |
| Other values (98660) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85739 ? |
|---|---|
| Unique (%) | 72.5% |
Sample
| 1st row | 00010242fe8c5a6d1ba2dd792cb16214 |
|---|---|
| 2nd row | 130898c0987d1801452a8ed92a670612 |
| 3rd row | 532ed5e14e24ae1f0d735b91524b98b9 |
| 4th row | 6f8c31653edb8c83e1a739408b5ff750 |
| 5th row | 7d19f4ef4d04461989632411b7e588b9 |
Common Values
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| Other values (98655) | 118017 |
Length
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| Other values (98655) | 118017 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 237711 | 6.3% |
| 6 | 237574 | 6.3% |
| b | 237565 | 6.3% |
| e | 237315 | 6.3% |
| 3 | 236962 | 6.3% |
| c | 236920 | 6.3% |
| 7 | 236861 | 6.3% |
| 8 | 236857 | 6.3% |
| 1 | 236825 | 6.3% |
| a | 236543 | 6.2% |
| Other values (6) | 1414947 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2365838 | |
| Lowercase Letter | 1420242 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 237711 | |
| 6 | 237574 | |
| 3 | 236962 | |
| 7 | 236861 | |
| 8 | 236857 | |
| 1 | 236825 | |
| 2 | 236349 | |
| 9 | 236003 | |
| 0 | 235394 | |
| 5 | 235302 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 237565 | |
| e | 237315 | |
| c | 236920 | |
| a | 236543 | |
| f | 236195 | |
| d | 235704 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2365838 | |
| Latin | 1420242 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 237711 | |
| 6 | 237574 | |
| 3 | 236962 | |
| 7 | 236861 | |
| 8 | 236857 | |
| 1 | 236825 | |
| 2 | 236349 | |
| 9 | 236003 | |
| 0 | 235394 | |
| 5 | 235302 |
Latin
| Value | Count | Frequency (%) |
| b | 237565 | |
| e | 237315 | |
| c | 236920 | |
| a | 236543 | |
| f | 236195 | |
| d | 235704 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 237711 | 6.3% |
| 6 | 237574 | 6.3% |
| b | 237565 | 6.3% |
| e | 237315 | 6.3% |
| 3 | 236962 | 6.3% |
| c | 236920 | 6.3% |
| 7 | 236861 | 6.3% |
| 8 | 236857 | 6.3% |
| 1 | 236825 | 6.3% |
| a | 236543 | 6.2% |
| Other values (6) | 1414947 |
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.196509318 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6994522013 |
|---|---|
| Coefficient of variation (CV) | 0.5845773122 |
| Kurtosis | 103.373708 |
| Mean | 1.196509318 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.552581474 |
| Sum | 141565 |
| Variance | 0.4892333819 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103652 | |
| 2 | 10316 | 8.7% |
| 3 | 2395 | 2.0% |
| 4 | 995 | 0.8% |
| 5 | 472 | 0.4% |
| 6 | 265 | 0.2% |
| 7 | 61 | 0.1% |
| 8 | 37 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 26 | < 0.1% |
| Other values (11) | 67 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 103652 | |
| 2 | 10316 | 8.7% |
| 3 | 2395 | 2.0% |
| 4 | 995 | 0.8% |
| 5 | 472 | 0.4% |
| 6 | 265 | 0.2% |
| 7 | 61 | 0.1% |
| 8 | 37 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 26 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
| Distinct | 32951 |
|---|---|
| Distinct (%) | 27.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 |
|---|---|
| 99a4788cb24856965c36a24e339b6058 | 528 |
| 422879e10f46682990de24d770e7f83d | 508 |
| 389d119b48cf3043d311335e499d9c6b | 406 |
| 368c6c730842d78016ad823897a372db | 398 |
| Other values (32946) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17344 ? |
|---|---|
| Unique (%) | 14.7% |
Sample
| 1st row | 4244733e06e7ecb4970a6e2683c13e61 |
|---|---|
| 2nd row | 4244733e06e7ecb4970a6e2683c13e61 |
| 3rd row | 4244733e06e7ecb4970a6e2683c13e61 |
| 4th row | 4244733e06e7ecb4970a6e2683c13e61 |
| 5th row | 4244733e06e7ecb4970a6e2683c13e61 |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 528 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 508 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 406 | 0.3% |
| 368c6c730842d78016ad823897a372db | 398 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 391 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 357 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 327 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 295 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 278 | 0.2% |
| Other values (32941) | 114291 |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 528 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 508 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 406 | 0.3% |
| 368c6c730842d78016ad823897a372db | 398 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 391 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 357 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 327 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 295 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 278 | 0.2% |
| Other values (32941) | 114291 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 243136 | 6.4% |
| 9 | 241101 | 6.4% |
| e | 238901 | 6.3% |
| 8 | 238256 | 6.3% |
| 7 | 238171 | 6.3% |
| 4 | 237494 | 6.3% |
| a | 237300 | 6.3% |
| c | 236404 | 6.2% |
| 0 | 236283 | 6.2% |
| 2 | 236127 | 6.2% |
| Other values (6) | 1402907 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2375922 | |
| Lowercase Letter | 1410158 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 243136 | |
| 9 | 241101 | |
| 8 | 238256 | |
| 7 | 238171 | |
| 4 | 237494 | |
| 0 | 236283 | |
| 2 | 236127 | |
| 6 | 235751 | |
| 5 | 235621 | |
| 1 | 233982 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 238901 | |
| a | 237300 | |
| c | 236404 | |
| b | 235077 | |
| d | 232766 | |
| f | 229710 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2375922 | |
| Latin | 1410158 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 243136 | |
| 9 | 241101 | |
| 8 | 238256 | |
| 7 | 238171 | |
| 4 | 237494 | |
| 0 | 236283 | |
| 2 | 236127 | |
| 6 | 235751 | |
| 5 | 235621 | |
| 1 | 233982 |
Latin
| Value | Count | Frequency (%) |
| e | 238901 | |
| a | 237300 | |
| c | 236404 | |
| b | 235077 | |
| d | 232766 | |
| f | 229710 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 243136 | 6.4% |
| 9 | 241101 | 6.4% |
| e | 238901 | 6.3% |
| 8 | 238256 | 6.3% |
| 7 | 238171 | 6.3% |
| 4 | 237494 | 6.3% |
| a | 237300 | 6.3% |
| c | 236404 | 6.2% |
| 0 | 236283 | 6.2% |
| 2 | 236127 | 6.2% |
| Other values (6) | 1402907 |
| Distinct | 3095 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| 4a3ca9315b744ce9f8e9374361493884 | 2155 |
|---|---|
| 6560211a19b47992c3666cc44a7e94c0 | 2130 |
| 1f50f920176fa81dab994f9023523100 | 2017 |
| cc419e0650a3c5ba77189a1882b7556a | 1893 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1662 |
| Other values (3090) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 487 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 48436dade18ac8b2bce089ec2a041202 |
|---|---|
| 2nd row | 48436dade18ac8b2bce089ec2a041202 |
| 3rd row | 48436dade18ac8b2bce089ec2a041202 |
| 4th row | 48436dade18ac8b2bce089ec2a041202 |
| 5th row | 48436dade18ac8b2bce089ec2a041202 |
Common Values
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2155 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2130 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2017 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1893 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1662 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1530 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1477 | 1.2% |
| 7c67e1448b00f6e969d365cea6b010ab | 1463 | 1.2% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1245 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1240 | 1.0% |
| Other values (3085) | 101503 |
Length
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2155 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2130 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2017 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1893 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1662 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1530 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1477 | 1.2% |
| 7c67e1448b00f6e969d365cea6b010ab | 1463 | 1.2% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1245 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1240 | 1.0% |
| Other values (3085) | 101503 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 256849 | 6.8% |
| c | 250008 | 6.6% |
| 4 | 248500 | 6.6% |
| 6 | 243523 | 6.4% |
| 0 | 242859 | 6.4% |
| a | 241366 | 6.4% |
| b | 240804 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235028 | 6.2% |
| 2 | 233712 | 6.2% |
| Other values (6) | 1352685 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2394716 | |
| Lowercase Letter | 1391364 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 256849 | |
| 4 | 248500 | |
| 6 | 243523 | |
| 0 | 242859 | |
| 3 | 240746 | |
| 9 | 235028 | |
| 2 | 233712 | |
| 8 | 231762 | |
| 5 | 231061 | |
| 7 | 230676 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 250008 | |
| a | 241366 | |
| b | 240804 | |
| e | 222610 | |
| f | 219175 | |
| d | 217401 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2394716 | |
| Latin | 1391364 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 256849 | |
| 4 | 248500 | |
| 6 | 243523 | |
| 0 | 242859 | |
| 3 | 240746 | |
| 9 | 235028 | |
| 2 | 233712 | |
| 8 | 231762 | |
| 5 | 231061 | |
| 7 | 230676 |
Latin
| Value | Count | Frequency (%) |
| c | 250008 | |
| a | 241366 | |
| b | 240804 | |
| e | 222610 | |
| f | 219175 | |
| d | 217401 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 256849 | 6.8% |
| c | 250008 | 6.6% |
| 4 | 248500 | 6.6% |
| 6 | 243523 | 6.4% |
| 0 | 242859 | 6.4% |
| a | 241366 | 6.4% |
| b | 240804 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235028 | 6.2% |
| 2 | 233712 | 6.2% |
| Other values (6) | 1352685 |
| Distinct | 93317 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017-08-14 20:43:31 | 63 |
|---|---|
| 2017-10-05 17:44:41 | 38 |
| 2017-04-27 09:10:13 | 29 |
| 2017-06-15 16:15:08 | 26 |
| 2018-02-27 12:28:15 | 24 |
| Other values (93312) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247985 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 76912 ? |
|---|---|
| Unique (%) | 65.0% |
Sample
| 1st row | 2017-09-19 09:45:35 |
|---|---|
| 2nd row | 2017-07-05 02:44:11 |
| 3rd row | 2018-05-23 10:56:25 |
| 4th row | 2017-08-07 18:55:08 |
| 5th row | 2017-08-16 22:05:11 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 20:43:31 | 63 | 0.1% |
| 2017-10-05 17:44:41 | 38 | < 0.1% |
| 2017-04-27 09:10:13 | 29 | < 0.1% |
| 2017-06-15 16:15:08 | 26 | < 0.1% |
| 2018-02-27 12:28:15 | 24 | < 0.1% |
| 2017-11-30 14:16:34 | 24 | < 0.1% |
| 2017-03-15 23:39:26 | 24 | < 0.1% |
| 2018-05-15 15:30:28 | 24 | < 0.1% |
| 2017-07-13 15:10:17 | 24 | < 0.1% |
| 2017-12-14 11:55:17 | 22 | < 0.1% |
| Other values (93307) | 118017 |
Length
| Value | Count | Frequency (%) |
| 2017-11-30 | 1753 | 0.7% |
| 2017-12-07 | 794 | 0.3% |
| 2018-04-19 | 729 | 0.3% |
| 2018-05-10 | 696 | 0.3% |
| 2018-01-18 | 689 | 0.3% |
| 2018-03-08 | 681 | 0.3% |
| 2018-08-07 | 678 | 0.3% |
| 2018-02-22 | 673 | 0.3% |
| 2018-03-22 | 670 | 0.3% |
| 2018-03-01 | 663 | 0.3% |
| Other values (40674) | 228604 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 379322 | |
| 1 | 364451 | |
| 2 | 289783 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 118675 | 5.3% |
| 118315 | 5.3% | |
| 3 | 114155 | 5.1% |
| 5 | 111990 | 5.0% |
| 7 | 102126 | 4.5% |
| Other values (3) | 175908 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656410 | |
| Dash Punctuation | 236630 | 10.5% |
| Other Punctuation | 236630 | 10.5% |
| Space Separator | 118315 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 379322 | |
| 1 | 364451 | |
| 2 | 289783 | |
| 8 | 118675 | 7.2% |
| 3 | 114155 | 6.9% |
| 5 | 111990 | 6.8% |
| 7 | 102126 | 6.2% |
| 4 | 79403 | 4.8% |
| 6 | 49606 | 3.0% |
| 9 | 46899 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236630 |
Space Separator
| Value | Count | Frequency (%) |
| 118315 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247985 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 379322 | |
| 1 | 364451 | |
| 2 | 289783 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 118675 | 5.3% |
| 118315 | 5.3% | |
| 3 | 114155 | 5.1% |
| 5 | 111990 | 5.0% |
| 7 | 102126 | 4.5% |
| Other values (3) | 175908 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 379322 | |
| 1 | 364451 | |
| 2 | 289783 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 118675 | 5.3% |
| 118315 | 5.3% | |
| 3 | 114155 | 5.1% |
| 5 | 111990 | 5.0% |
| 7 | 102126 | 4.5% |
| Other values (3) | 175908 |
| Distinct | 5968 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.651027 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 184.1096263 |
|---|---|
| Coefficient of variation (CV) | 1.525968165 |
| Kurtosis | 119.1492968 |
| Mean | 120.651027 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.892242206 |
| Sum | 14274826.26 |
| Variance | 33896.35449 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2619 | 2.2% |
| 69.9 | 2113 | 1.8% |
| 49.9 | 2051 | 1.7% |
| 89.9 | 1644 | 1.4% |
| 99.9 | 1526 | 1.3% |
| 39.9 | 1403 | 1.2% |
| 29.9 | 1387 | 1.2% |
| 19.9 | 1284 | 1.1% |
| 79.9 | 1282 | 1.1% |
| 29.99 | 1228 | 1.0% |
| Other values (5958) | 101778 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
| Distinct | 6999 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.03302362 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 390 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.28 |
| Q3 | 21.18 |
| 95-th percentile | 45.3 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.1 |
Descriptive statistics
| Standard deviation | 15.8365227 |
|---|---|
| Coefficient of variation (CV) | 0.7905208419 |
| Kurtosis | 57.63691305 |
| Mean | 20.03302362 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.543441345 |
| Sum | 2370207.19 |
| Variance | 250.7954513 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3861 | 3.3% |
| 7.78 | 2355 | 2.0% |
| 11.85 | 1999 | 1.7% |
| 14.1 | 1992 | 1.7% |
| 18.23 | 1632 | 1.4% |
| 7.39 | 1573 | 1.3% |
| 16.11 | 1211 | 1.0% |
| 15.23 | 1064 | 0.9% |
| 8.72 | 970 | 0.8% |
| 16.79 | 930 | 0.8% |
| Other values (6989) | 100728 |
| Value | Count | Frequency (%) |
| 0 | 390 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.09406246 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.728555048 |
|---|---|
| Coefficient of variation (CV) | 0.6659172345 |
| Kurtosis | 346.9364476 |
| Mean | 1.09406246 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.89992468 |
| Sum | 129444 |
| Variance | 0.530792458 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 113230 | |
| 2 | 3389 | 2.9% |
| 3 | 651 | 0.6% |
| 4 | 316 | 0.3% |
| 5 | 190 | 0.2% |
| 6 | 132 | 0.1% |
| 7 | 91 | 0.1% |
| 8 | 60 | 0.1% |
| 9 | 49 | < 0.1% |
| 10 | 41 | < 0.1% |
| Other values (19) | 166 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 113230 | |
| 2 | 3389 | 2.9% |
| 3 | 651 | 0.6% |
| 4 | 316 | 0.3% |
| 5 | 190 | 0.2% |
| 6 | 132 | 0.1% |
| 7 | 91 | 0.1% |
| 8 | 60 | 0.1% |
| 9 | 49 | < 0.1% |
| 10 | 41 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.4 MiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6332 |
| debit_card | 1699 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.79882517 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1159348 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | boleto |
| 3rd row | credit_card |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 87266 | |
| boleto | 23018 | 19.5% |
| voucher | 6332 | 5.4% |
| debit_card | 1699 | 1.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| credit_card | 87266 | |
| boleto | 23018 | 19.5% |
| voucher | 6332 | 5.4% |
| debit_card | 1699 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 182563 | |
| r | 182563 | |
| d | 177930 | |
| e | 118315 | |
| t | 111983 | |
| i | 88965 | |
| _ | 88965 | |
| a | 88965 | |
| o | 52368 | 4.5% |
| b | 24717 | 2.1% |
| Other values (4) | 42014 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1070383 | |
| Connector Punctuation | 88965 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 182563 | |
| r | 182563 | |
| d | 177930 | |
| e | 118315 | |
| t | 111983 | |
| i | 88965 | |
| a | 88965 | |
| o | 52368 | 4.9% |
| b | 24717 | 2.3% |
| l | 23018 | 2.2% |
| Other values (3) | 18996 | 1.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 88965 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1070383 | |
| Common | 88965 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 182563 | |
| r | 182563 | |
| d | 177930 | |
| e | 118315 | |
| t | 111983 | |
| i | 88965 | |
| a | 88965 | |
| o | 52368 | 4.9% |
| b | 24717 | 2.3% |
| l | 23018 | 2.2% |
| Other values (3) | 18996 | 1.8% |
Common
| Value | Count | Frequency (%) |
| _ | 88965 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1159348 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 182563 | |
| r | 182563 | |
| d | 177930 | |
| e | 118315 | |
| t | 111983 | |
| i | 88965 | |
| _ | 88965 | |
| a | 88965 | |
| o | 52368 | 4.5% |
| b | 24717 | 2.1% |
| Other values (4) | 42014 | 3.6% |
payment_installments
Real number (ℝ≥0)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.943498288 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.778022129 |
|---|---|
| Coefficient of variation (CV) | 0.943782485 |
| Kurtosis | 2.506924009 |
| Mean | 2.943498288 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.618521535 |
| Sum | 348260 |
| Variance | 7.717406951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58945 | |
| 2 | 13768 | 11.6% |
| 3 | 11831 | 10.0% |
| 4 | 8025 | 6.8% |
| 10 | 6923 | 5.9% |
| 5 | 6058 | 5.1% |
| 8 | 5108 | 4.3% |
| 6 | 4653 | 3.9% |
| 7 | 1837 | 1.6% |
| 9 | 730 | 0.6% |
| Other values (14) | 437 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 58945 | |
| 2 | 13768 | 11.6% |
| 3 | 11831 | 10.0% |
| 4 | 8025 | 6.8% |
| 5 | 6058 | 5.1% |
| 6 | 4653 | 3.9% |
| 7 | 1837 | 1.6% |
| 8 | 5108 | 4.3% |
| 9 | 730 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 21 | < 0.1% |
| 18 | 38 | |
| 17 | 7 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 93 | |
| 14 | 16 | < 0.1% |
| Distinct | 28938 |
|---|---|
| Distinct (%) | 24.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.575651 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.19 |
| Q1 | 60.85 |
| median | 108.2 |
| Q3 | 189.26 |
| 95-th percentile | 514.766 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.41 |
Descriptive statistics
| Standard deviation | 267.1046609 |
|---|---|
| Coefficient of variation (CV) | 1.547754039 |
| Kurtosis | 508.217825 |
| Mean | 172.575651 |
| Median Absolute Deviation (MAD) | 56.64 |
| Skewness | 14.08641401 |
| Sum | 20418288.15 |
| Variance | 71344.8999 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 350 | 0.3% |
| 100 | 299 | 0.3% |
| 20 | 285 | 0.2% |
| 77.57 | 250 | 0.2% |
| 35 | 163 | 0.1% |
| 73.34 | 159 | 0.1% |
| 30 | 136 | 0.1% |
| 116.94 | 132 | 0.1% |
| 56.78 | 122 | 0.1% |
| 107.78 | 119 | 0.1% |
| Other values (28928) | 116300 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | |
| 0.11 | 2 | < 0.1% |
| 0.13 | 2 | < 0.1% |
| 0.14 | 5 |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6922.21 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1709 |
| Missing (%) | 1.4% |
| Memory size | 8.9 MiB |
| cama_mesa_banho | |
|---|---|
| beleza_saude | |
| esporte_lazer | |
| moveis_decoracao | |
| informatica_acessorios | |
| Other values (68) |
Length
| Max length | 46 |
|---|---|
| Median length | 15 |
| Mean length | 14.87630139 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1734666 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | cool_stuff |
|---|---|
| 2nd row | cool_stuff |
| 3rd row | cool_stuff |
| 4th row | cool_stuff |
| 5th row | cool_stuff |
Common Values
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11990 | 10.1% |
| beleza_saude | 10030 | 8.5% |
| esporte_lazer | 9005 | 7.6% |
| moveis_decoracao | 8833 | 7.5% |
| informatica_acessorios | 8151 | 6.9% |
| utilidades_domesticas | 7380 | 6.2% |
| relogios_presentes | 6213 | 5.3% |
| telefonia | 4726 | 4.0% |
| ferramentas_jardim | 4590 | 3.9% |
| automotivo | 4400 | 3.7% |
| Other values (63) | 41288 |
Length
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11990 | 10.3% |
| beleza_saude | 10030 | 8.6% |
| esporte_lazer | 9005 | 7.7% |
| moveis_decoracao | 8833 | 7.6% |
| informatica_acessorios | 8151 | 7.0% |
| utilidades_domesticas | 7380 | 6.3% |
| relogios_presentes | 6213 | 5.3% |
| telefonia | 4726 | 4.1% |
| ferramentas_jardim | 4590 | 3.9% |
| automotivo | 4400 | 3.8% |
| Other values (63) | 41288 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 210548 | |
| a | 208844 | |
| s | 172862 | |
| o | 171626 | |
| i | 115177 | 6.6% |
| r | 111462 | 6.4% |
| _ | 110499 | 6.4% |
| t | 83293 | 4.8% |
| c | 82443 | 4.8% |
| m | 78690 | 4.5% |
| Other values (18) | 389222 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1623865 | |
| Connector Punctuation | 110499 | 6.4% |
| Decimal Number | 302 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 210548 | |
| a | 208844 | |
| s | 172862 | |
| o | 171626 | |
| i | 115177 | 7.1% |
| r | 111462 | 6.9% |
| t | 83293 | 5.1% |
| c | 82443 | 5.1% |
| m | 78690 | 4.8% |
| n | 59162 | 3.6% |
| Other values (16) | 329758 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 110499 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1623865 | |
| Common | 110801 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 210548 | |
| a | 208844 | |
| s | 172862 | |
| o | 171626 | |
| i | 115177 | 7.1% |
| r | 111462 | 6.9% |
| t | 83293 | 5.1% |
| c | 82443 | 5.1% |
| m | 78690 | 4.8% |
| n | 59162 | 3.6% |
| Other values (16) | 329758 |
Common
| Value | Count | Frequency (%) |
| _ | 110499 | |
| 2 | 302 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1734666 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 210548 | |
| a | 208844 | |
| s | 172862 | |
| o | 171626 | |
| i | 115177 | 6.6% |
| r | 111462 | 6.4% |
| _ | 110499 | 6.4% |
| t | 83293 | 4.8% |
| c | 82443 | 4.8% |
| m | 78690 | 4.5% |
| Other values (18) | 389222 |
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1709 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.7677821 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.03337512 |
|---|---|
| Coefficient of variation (CV) | 0.2057377778 |
| Kurtosis | 0.1496973763 |
| Mean | 48.7677821 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.9049602992 |
| Sum | 5686616 |
| Variance | 100.6686163 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8679 | 7.3% |
| 60 | 8071 | 6.8% |
| 56 | 6847 | 5.8% |
| 58 | 6819 | 5.8% |
| 57 | 6302 | 5.3% |
| 55 | 5834 | 4.9% |
| 54 | 5531 | 4.7% |
| 53 | 4357 | 3.7% |
| 52 | 4328 | 3.7% |
| 49 | 3690 | 3.1% |
| Other values (56) | 56148 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 15 | < 0.1% |
| 10 | 9 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 38 | |
| 13 | 26 | |
| 14 | 47 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 174 | 0.1% |
| 63 | 1350 | |
| 62 | 167 | 0.1% |
| 61 | 241 | 0.2% |
| Distinct | 2960 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 1709 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.944008 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 346 |
| median | 600 |
| Q3 | 983 |
| 95-th percentile | 2123 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 652.5786361 |
|---|---|
| Coefficient of variation (CV) | 0.8303118662 |
| Kurtosis | 4.930172973 |
| Mean | 785.944008 |
| Median Absolute Deviation (MAD) | 296 |
| Skewness | 2.012211344 |
| Sum | 91645787 |
| Variance | 425858.8762 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 711 | 0.6% |
| 1893 | 667 | 0.6% |
| 348 | 648 | 0.5% |
| 903 | 594 | 0.5% |
| 492 | 594 | 0.5% |
| 245 | 587 | 0.5% |
| 366 | 537 | 0.5% |
| 236 | 516 | 0.4% |
| 340 | 487 | 0.4% |
| 919 | 442 | 0.4% |
| Other values (2950) | 110823 | |
| (Missing) | 1709 | 1.4% |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1709 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.205143818 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.717429086 |
|---|---|
| Coefficient of variation (CV) | 0.7788286064 |
| Kurtosis | 4.820243289 |
| Mean | 2.205143818 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.908767007 |
| Sum | 257133 |
| Variance | 2.949562667 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58960 | |
| 2 | 23054 | 19.5% |
| 3 | 12980 | 11.0% |
| 4 | 8863 | 7.5% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.7% |
| 10 | 354 | 0.3% |
| 9 | 318 | 0.3% |
| Other values (9) | 199 | 0.2% |
| (Missing) | 1709 | 1.4% |
| Value | Count | Frequency (%) |
| 1 | 58960 | |
| 2 | 23054 | 19.5% |
| 3 | 12980 | 11.0% |
| 4 | 8863 | 7.5% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.7% |
| 9 | 318 | 0.3% |
| 10 | 354 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 354 |
| Distinct | 2204 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2112.331011 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3786.717861 |
|---|---|
| Coefficient of variation (CV) | 1.792672569 |
| Kurtosis | 16.0168339 |
| Mean | 2112.331011 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.582890275 |
| Sum | 249878197 |
| Variance | 14339232.16 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 7093 | 6.0% |
| 150 | 5411 | 4.6% |
| 250 | 4741 | 4.0% |
| 300 | 4430 | 3.7% |
| 400 | 3787 | 3.2% |
| 100 | 3666 | 3.1% |
| 350 | 3291 | 2.8% |
| 500 | 2856 | 2.4% |
| 600 | 2838 | 2.4% |
| 700 | 2149 | 1.8% |
| Other values (2194) | 78033 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 991 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 303 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.26522676 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.18903807 |
|---|---|
| Coefficient of variation (CV) | 0.53490556 |
| Kurtosis | 3.678790799 |
| Mean | 30.26522676 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.745703959 |
| Sum | 3580225 |
| Variance | 262.0849537 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 18362 | 15.5% |
| 20 | 10999 | 9.3% |
| 30 | 7952 | 6.7% |
| 17 | 6203 | 5.2% |
| 18 | 5909 | 5.0% |
| 19 | 4898 | 4.1% |
| 25 | 4871 | 4.1% |
| 40 | 4360 | 3.7% |
| 22 | 4000 | 3.4% |
| 50 | 3163 | 2.7% |
| Other values (89) | 47578 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 138 | 0.1% |
| 15 | 220 | 0.2% |
| 16 | 18362 |
| Value | Count | Frequency (%) |
| 105 | 335 | |
| 104 | 35 | < 0.1% |
| 103 | 46 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 108 | 0.1% |
| 100 | 429 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.6200093 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.45394074 |
|---|---|
| Coefficient of variation (CV) | 0.8095026001 |
| Kurtosis | 7.276747824 |
| Mean | 16.6200093 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.238831941 |
| Sum | 1966064 |
| Variance | 181.0085215 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10374 | 8.8% |
| 20 | 6915 | 5.8% |
| 15 | 6896 | 5.8% |
| 12 | 6523 | 5.5% |
| 11 | 6432 | 5.4% |
| 2 | 5254 | 4.4% |
| 4 | 4911 | 4.2% |
| 8 | 4873 | 4.1% |
| 5 | 4776 | 4.0% |
| 16 | 4762 | 4.0% |
| Other values (92) | 56579 |
| Value | Count | Frequency (%) |
| 2 | 5254 | |
| 3 | 2821 | 2.4% |
| 4 | 4911 | |
| 5 | 4776 | |
| 6 | 3576 | 3.0% |
| 7 | 4387 | |
| 8 | 4873 | |
| 9 | 3408 | 2.9% |
| 10 | 10374 | |
| 11 | 6432 |
| Value | Count | Frequency (%) |
| 105 | 139 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 43 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.07507502 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.74931107 |
|---|---|
| Coefficient of variation (CV) | 0.509177589 |
| Kurtosis | 4.552246314 |
| Mean | 23.07507502 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.707015517 |
| Sum | 2729666 |
| Variance | 138.0463105 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12701 | 10.7% |
| 11 | 11146 | 9.4% |
| 15 | 9376 | 7.9% |
| 16 | 8808 | 7.4% |
| 30 | 8045 | 6.8% |
| 12 | 5711 | 4.8% |
| 13 | 5492 | 4.6% |
| 14 | 4846 | 4.1% |
| 18 | 4192 | 3.5% |
| 40 | 4158 | 3.5% |
| Other values (85) | 43820 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 11146 | |
| 12 | 5711 | |
| 13 | 5492 | |
| 14 | 4846 | |
| 15 | 9376 |
| Value | Count | Frequency (%) |
| 118 | 8 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
| Distinct | 2246 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24440.7907 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2972 |
| Q1 | 6429 |
| median | 13660 |
| Q3 | 27946.5 |
| 95-th percentile | 88308 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 21517.5 |
Descriptive statistics
| Standard deviation | 27571.67946 |
|---|---|
| Coefficient of variation (CV) | 1.12810096 |
| Kurtosis | 0.9376893775 |
| Mean | 24440.7907 |
| Median Absolute Deviation (MAD) | 8123 |
| Skewness | 1.556334563 |
| Sum | 2891712152 |
| Variance | 760197508 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 8375 | 7.1% |
| 5849 | 2145 | 1.8% |
| 15025 | 2098 | 1.8% |
| 9015 | 1899 | 1.6% |
| 13405 | 1678 | 1.4% |
| 8577 | 1556 | 1.3% |
| 4782 | 1549 | 1.3% |
| 3204 | 1477 | 1.2% |
| 4160 | 1268 | 1.1% |
| 13232 | 1255 | 1.1% |
| Other values (2236) | 95015 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 41 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 323 | |
| 1031 | 129 | 0.1% |
| 1035 | 18 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 25 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 61 | |
| 99300 | 2 | < 0.1% |
| 98975 | 22 | < 0.1% |
| 98920 | 2 | < 0.1% |
| 98910 | 14 | < 0.1% |
| 98803 | 66 | |
| 98780 | 4 | < 0.1% |
| Distinct | 611 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| sao paulo | |
|---|---|
| ibitinga | |
| curitiba | 3158 |
| santo andre | 3149 |
| sao jose do rio preto | 2693 |
| Other values (606) |
Length
| Max length | 40 |
|---|---|
| Median length | 9 |
| Mean length | 10.10233698 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1195258 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 9 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | volta redonda |
|---|---|
| 2nd row | volta redonda |
| 3rd row | volta redonda |
| 4th row | volta redonda |
| 5th row | volta redonda |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 29294 | |
| ibitinga | 8375 | 7.1% |
| curitiba | 3158 | 2.7% |
| santo andre | 3149 | 2.7% |
| sao jose do rio preto | 2693 | 2.3% |
| belo horizonte | 2688 | 2.3% |
| rio de janeiro | 2535 | 2.1% |
| guarulhos | 2456 | 2.1% |
| ribeirao preto | 2374 | 2.0% |
| maringa | 2293 | 1.9% |
| Other values (601) | 59300 |
Length
| Value | Count | Frequency (%) |
| sao | 36363 | 17.9% |
| paulo | 29575 | 14.5% |
| ibitinga | 8375 | 4.1% |
| rio | 5930 | 2.9% |
| do | 5524 | 2.7% |
| preto | 5518 | 2.7% |
| de | 4192 | 2.1% |
| jose | 4085 | 2.0% |
| santo | 3270 | 1.6% |
| andre | 3164 | 1.6% |
| Other values (640) | 97269 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 198783 | |
| o | 146217 | |
| i | 102117 | 8.5% |
| 85010 | 7.1% | |
| r | 78219 | 6.5% |
| s | 76220 | 6.4% |
| e | 64172 | 5.4% |
| u | 62906 | 5.3% |
| p | 58420 | 4.9% |
| l | 56918 | 4.8% |
| Other values (31) | 266276 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1109029 | |
| Space Separator | 85010 | 7.1% |
| Other Punctuation | 614 | 0.1% |
| Modifier Symbol | 369 | < 0.1% |
| Dash Punctuation | 164 | < 0.1% |
| Open Punctuation | 31 | < 0.1% |
| Close Punctuation | 31 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Nonspacing Mark | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 198783 | |
| o | 146217 | |
| i | 102117 | |
| r | 78219 | 7.1% |
| s | 76220 | 6.9% |
| e | 64172 | 5.8% |
| u | 62906 | 5.7% |
| p | 58420 | 5.3% |
| l | 56918 | 5.1% |
| t | 47317 | 4.3% |
| Other values (14) | 217740 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 347 | |
| / | 141 | |
| . | 76 | 12.4% |
| @ | 38 | 6.2% |
| , | 6 | 1.0% |
| \ | 6 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2 | |
| 2 | 2 | |
| 5 | 2 | |
| 0 | 1 | |
| 8 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 85010 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 369 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 164 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 31 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 31 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1109029 | |
| Common | 86227 | 7.2% |
| Inherited | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 198783 | |
| o | 146217 | |
| i | 102117 | |
| r | 78219 | 7.1% |
| s | 76220 | 6.9% |
| e | 64172 | 5.8% |
| u | 62906 | 5.7% |
| p | 58420 | 5.3% |
| l | 56918 | 5.1% |
| t | 47317 | 4.3% |
| Other values (14) | 217740 |
Common
| Value | Count | Frequency (%) |
| 85010 | ||
| ´ | 369 | 0.4% |
| ' | 347 | 0.4% |
| - | 164 | 0.2% |
| / | 141 | 0.2% |
| . | 76 | 0.1% |
| @ | 38 | < 0.1% |
| ( | 31 | < 0.1% |
| ) | 31 | < 0.1% |
| , | 6 | < 0.1% |
| Other values (6) | 14 | < 0.1% |
Inherited
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1194887 | |
| Latin 1 Sup | 369 | < 0.1% |
| Diacriticals | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 198783 | |
| o | 146217 | |
| i | 102117 | 8.5% |
| 85010 | 7.1% | |
| r | 78219 | 6.5% |
| s | 76220 | 6.4% |
| e | 64172 | 5.4% |
| u | 62906 | 5.3% |
| p | 58420 | 4.9% |
| l | 56918 | 4.8% |
| Other values (29) | 265905 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| ´ | 369 |
Diacriticals
| Value | Count | Frequency (%) |
| ̃ | 2 |
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 5036 |
| SC | 4271 |
| Other values (18) | 6216 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 236630 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 84384 | |
| MG | 9314 | 7.9% |
| PR | 9094 | 7.7% |
| RJ | 5036 | 4.3% |
| SC | 4271 | 3.6% |
| RS | 2294 | 1.9% |
| DF | 949 | 0.8% |
| BA | 700 | 0.6% |
| GO | 550 | 0.5% |
| PE | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
Length
| Value | Count | Frequency (%) |
| sp | 84384 | |
| mg | 9314 | 7.9% |
| pr | 9094 | 7.7% |
| rj | 5036 | 4.3% |
| sc | 4271 | 3.6% |
| rs | 2294 | 1.9% |
| df | 949 | 0.8% |
| ba | 700 | 0.6% |
| go | 550 | 0.5% |
| pe | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 94007 | |
| S | 91409 | |
| R | 16494 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 236630 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 94007 | |
| S | 91409 | |
| R | 16494 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 236630 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 94007 | |
| S | 91409 | |
| R | 16494 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 236630 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 94007 | |
| S | 91409 | |
| R | 16494 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
| Distinct | 98452 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 |
|---|---|
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 |
| f28281373ab8815bafafe371218f02ce | 29 |
| 8823bba1e3301fee652eb06de8ef9435 | 26 |
| cc074f1c33940c4f0dd904705f98e39e | 24 |
| Other values (98447) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85382 ? |
|---|---|
| Unique (%) | 72.2% |
Sample
| 1st row | 97ca439bc427b48bc1cd7177abe71365 |
|---|---|
| 2nd row | b11cba360bbe71410c291b764753d37f |
| 3rd row | af01c4017c5ab46df6cc810e069e654a |
| 4th row | 8304ff37d8b16b57086fa283fe0c44f8 |
| 5th row | 426f43a82185969503fb3c86241a9535 |
Common Values
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| Other values (98442) | 118020 |
Length
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| Other values (98442) | 118020 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 237429 | 6.3% |
| 6 | 237329 | 6.3% |
| 5 | 237083 | 6.3% |
| b | 237015 | 6.3% |
| d | 236979 | 6.3% |
| 8 | 236859 | 6.3% |
| f | 236814 | 6.3% |
| 1 | 236665 | 6.3% |
| 0 | 236561 | 6.2% |
| 7 | 236489 | 6.2% |
| Other values (6) | 1416857 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2365058 | |
| Lowercase Letter | 1421022 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 237329 | |
| 5 | 237083 | |
| 8 | 236859 | |
| 1 | 236665 | |
| 0 | 236561 | |
| 7 | 236489 | |
| 2 | 236385 | |
| 9 | 236079 | |
| 3 | 235922 | |
| 4 | 235686 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 237429 | |
| b | 237015 | |
| d | 236979 | |
| f | 236814 | |
| c | 236419 | |
| e | 236366 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2365058 | |
| Latin | 1421022 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 237329 | |
| 5 | 237083 | |
| 8 | 236859 | |
| 1 | 236665 | |
| 0 | 236561 | |
| 7 | 236489 | |
| 2 | 236385 | |
| 9 | 236079 | |
| 3 | 235922 | |
| 4 | 235686 |
Latin
| Value | Count | Frequency (%) |
| a | 237429 | |
| b | 237015 | |
| d | 236979 | |
| f | 236814 | |
| c | 236419 | |
| e | 236366 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 237429 | 6.3% |
| 6 | 237329 | 6.3% |
| 5 | 237083 | 6.3% |
| b | 237015 | 6.3% |
| d | 236979 | 6.3% |
| 8 | 236859 | 6.3% |
| f | 236814 | 6.3% |
| 1 | 236665 | 6.3% |
| 0 | 236561 | 6.2% |
| 7 | 236489 | 6.2% |
| Other values (6) | 1416857 |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| 5 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 2 | 4201 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 118315 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5 |
|---|---|
| 2nd row | 5 |
| 3rd row | 4 |
| 4th row | 5 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 118315 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 118315 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118315 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 66370 | |
| 4 | 22352 | 18.9% |
| 1 | 15427 | 13.0% |
| 3 | 9965 | 8.4% |
| 2 | 4201 | 3.6% |
| Distinct | 4569 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 104226 |
| Missing (%) | 88.1% |
| Memory size | 5.1 MiB |
| Recomendo | 498 |
|---|---|
| recomendo | 404 |
| Bom | 332 |
| super recomendo | 311 |
| Excelente | 293 |
| Other values (4564) |
Length
| Max length | 26 |
|---|---|
| Median length | 11 |
| Mean length | 12.23379942 |
| Min length | 1 |
Characters and Unicode
| Total characters | 172362 |
|---|---|
| Distinct characters | 126 |
| Distinct categories | 14 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 3120 ? |
|---|---|
| Unique (%) | 22.1% |
Sample
| 1st row | super recomendo |
|---|---|
| 2nd row | O produto não foi entregu |
| 3rd row | Muito bom |
| 4th row | Muito bom |
| 5th row | qualidade ruim do produto |
Common Values
| Value | Count | Frequency (%) |
| Recomendo | 498 | 0.4% |
| recomendo | 404 | 0.3% |
| Bom | 332 | 0.3% |
| super recomendo | 311 | 0.3% |
| Excelente | 293 | 0.2% |
| Muito bom | 279 | 0.2% |
| Ótimo | 268 | 0.2% |
| Super recomendo | 257 | 0.2% |
| Ótimo | 238 | 0.2% |
| Otimo | 201 | 0.2% |
| Other values (4559) | 11008 | 9.3% |
| (Missing) | 104226 |
Length
| Value | Count | Frequency (%) |
| recomendo | 2485 | 9.2% |
| produto | 1589 | 5.9% |
| bom | 1528 | 5.7% |
| super | 1043 | 3.9% |
| muito | 1042 | 3.9% |
| não | 951 | 3.5% |
| ótimo | 807 | 3.0% |
| excelente | 769 | 2.8% |
| entrega | 728 | 2.7% |
| recebi | 450 | 1.7% |
| Other values (2112) | 15603 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 21420 | 12.4% |
| e | 18455 | 10.7% |
| 15344 | 8.9% | |
| r | 10013 | 5.8% |
| t | 9486 | 5.5% |
| a | 9268 | 5.4% |
| m | 8473 | 4.9% |
| d | 8290 | 4.8% |
| i | 8146 | 4.7% |
| n | 7741 | 4.5% |
| Other values (116) | 55726 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 133893 | |
| Uppercase Letter | 19045 | 11.0% |
| Space Separator | 15344 | 8.9% |
| Other Punctuation | 2703 | 1.6% |
| Decimal Number | 1270 | 0.7% |
| Other Symbol | 49 | < 0.1% |
| Dash Punctuation | 19 | < 0.1% |
| Modifier Symbol | 13 | < 0.1% |
| Math Symbol | 8 | < 0.1% |
| Close Punctuation | 7 | < 0.1% |
| Other values (4) | 11 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 21420 | |
| e | 18455 | |
| r | 10013 | 7.5% |
| t | 9486 | 7.1% |
| a | 9268 | 6.9% |
| m | 8473 | 6.3% |
| d | 8290 | 6.2% |
| i | 8146 | 6.1% |
| n | 7741 | 5.8% |
| c | 5992 | 4.5% |
| Other values (31) | 26609 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2553 | |
| R | 2065 | |
| O | 1693 | 8.9% |
| P | 1632 | 8.6% |
| M | 1457 | 7.7% |
| N | 1214 | 6.4% |
| S | 1057 | 5.6% |
| A | 994 | 5.2% |
| Ó | 931 | 4.9% |
| B | 902 | 4.7% |
| Other values (26) | 4547 |
Other Punctuation
| Value | Count | Frequency (%) |
| ! | 1213 | |
| . | 801 | |
| * | 404 | 14.9% |
| , | 155 | 5.7% |
| ? | 50 | 1.8% |
| / | 39 | 1.4% |
| % | 22 | 0.8% |
| : | 6 | 0.2% |
| ; | 4 | 0.1% |
| " | 3 | 0.1% |
| Other values (4) | 6 | 0.2% |
Other Symbol
| Value | Count | Frequency (%) |
| 👍 | 16 | |
| 😍 | 9 | |
| 👏 | 7 | |
| 🌟 | 6 | 12.2% |
| 💥 | 5 | 10.2% |
| 🚚 | 1 | 2.0% |
| 😀 | 1 | 2.0% |
| 🔟 | 1 | 2.0% |
| 👎 | 1 | 2.0% |
| 🤗 | 1 | 2.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 484 | |
| 1 | 424 | |
| 5 | 81 | 6.4% |
| 2 | 80 | 6.3% |
| 8 | 46 | 3.6% |
| 3 | 42 | 3.3% |
| 4 | 39 | 3.1% |
| 9 | 29 | 2.3% |
| 7 | 24 | 1.9% |
| 6 | 21 | 1.7% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 6 | |
| 🏻 | 3 | |
| 🏽 | 2 | 15.4% |
| 🏼 | 2 | 15.4% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6 | |
| ] | 1 | 14.3% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7 | |
| = | 1 | 12.5% |
Space Separator
| Value | Count | Frequency (%) |
| 15344 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 5 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 152939 | |
| Common | 19423 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 21420 | |
| e | 18455 | |
| r | 10013 | 6.5% |
| t | 9486 | 6.2% |
| a | 9268 | 6.1% |
| m | 8473 | 5.5% |
| d | 8290 | 5.4% |
| i | 8146 | 5.3% |
| n | 7741 | 5.1% |
| c | 5992 | 3.9% |
| Other values (68) | 45655 |
Common
| Value | Count | Frequency (%) |
| 15344 | ||
| ! | 1213 | 6.2% |
| . | 801 | 4.1% |
| 0 | 484 | 2.5% |
| 1 | 424 | 2.2% |
| * | 404 | 2.1% |
| , | 155 | 0.8% |
| 5 | 81 | 0.4% |
| 2 | 80 | 0.4% |
| ? | 50 | 0.3% |
| Other values (38) | 387 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 168670 | |
| Latin 1 Sup | 3636 | 2.1% |
| None | 45 | < 0.1% |
| Emoticons | 11 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 21420 | |
| e | 18455 | 10.9% |
| 15344 | 9.1% | |
| r | 10013 | 5.9% |
| t | 9486 | 5.6% |
| a | 9268 | 5.5% |
| m | 8473 | 5.0% |
| d | 8290 | 4.9% |
| i | 8146 | 4.8% |
| n | 7741 | 4.6% |
| Other values (75) | 52034 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| ã | 1144 | |
| Ó | 931 | |
| á | 361 | 9.9% |
| ç | 358 | 9.8% |
| é | 275 | 7.6% |
| ó | 247 | 6.8% |
| Ã | 74 | 2.0% |
| í | 64 | 1.8% |
| ê | 45 | 1.2% |
| É | 30 | 0.8% |
| Other values (17) | 107 | 2.9% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 9 | |
| 😀 | 1 | 9.1% |
| 😤 | 1 | 9.1% |
None
| Value | Count | Frequency (%) |
| 👍 | 16 | |
| 👏 | 7 | |
| 🌟 | 6 | 13.3% |
| 💥 | 5 | 11.1% |
| 🏻 | 3 | 6.7% |
| 🏽 | 2 | 4.4% |
| 🏼 | 2 | 4.4% |
| 🚚 | 1 | 2.2% |
| 🔟 | 1 | 2.2% |
| 👎 | 1 | 2.2% |
| Distinct | 36434 |
|---|---|
| Distinct (%) | 71.9% |
| Missing | 67650 |
| Missing (%) | 57.2% |
| Memory size | 9.9 MiB |
| Muito bom | 259 |
|---|---|
| Bom | 207 |
| muito bom | 137 |
| bom | 118 |
| Otimo | 116 |
| Other values (36429) |
Length
| Max length | 208 |
|---|---|
| Median length | 55 |
| Mean length | 71.77513076 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3636487 |
|---|---|
| Distinct characters | 212 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 5 ? |
Unique
| Unique | 29741 ? |
|---|---|
| Unique (%) | 58.7% |
Sample
| 1st row | Perfeito, produto entregue antes do combinado. |
|---|---|
| 2nd row | lannister como sempre, entregou certinho e dentro do prazo. recomendo muito |
| 3rd row | carrinho muito bonito |
| 4th row | Muito bom chegou bem antes do prazo, produto de ótima qualidade meu filho amou |
| 5th row | o carrinho veio com defeito. |
Common Values
| Value | Count | Frequency (%) |
| Muito bom | 259 | 0.2% |
| Bom | 207 | 0.2% |
| muito bom | 137 | 0.1% |
| bom | 118 | 0.1% |
| Otimo | 116 | 0.1% |
| Recomendo | 111 | 0.1% |
| otimo | 103 | 0.1% |
| Ok | 87 | 0.1% |
| Ótimo | 86 | 0.1% |
| Ótimo | 85 | 0.1% |
| Other values (36424) | 49356 | |
| (Missing) | 67650 |
Length
| Value | Count | Frequency (%) |
| o | 23487 | 3.8% |
| produto | 21348 | 3.4% |
| e | 20473 | 3.3% |
| a | 15615 | 2.5% |
| de | 14952 | 2.4% |
| não | 13630 | 2.2% |
| do | 13273 | 2.1% |
| que | 10862 | 1.8% |
| prazo | 9452 | 1.5% |
| muito | 9205 | 1.5% |
| Other values (20373) | 468376 |
Most occurring characters
| Value | Count | Frequency (%) |
| 576384 | ||
| o | 357423 | 9.8% |
| e | 348604 | 9.6% |
| a | 287966 | 7.9% |
| r | 204653 | 5.6% |
| i | 167459 | 4.6% |
| t | 164244 | 4.5% |
| d | 153473 | 4.2% |
| n | 141236 | 3.9% |
| s | 136679 | 3.8% |
| Other values (202) | 1098366 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2740678 | |
| Space Separator | 576384 | 15.9% |
| Uppercase Letter | 176403 | 4.9% |
| Other Punctuation | 98665 | 2.7% |
| Decimal Number | 25898 | 0.7% |
| Control | 14569 | 0.4% |
| Dash Punctuation | 1207 | < 0.1% |
| Close Punctuation | 784 | < 0.1% |
| Open Punctuation | 768 | < 0.1% |
| Other Symbol | 718 | < 0.1% |
| Other values (5) | 413 | < 0.1% |
Most frequent character per category
Other Symbol
| Value | Count | Frequency (%) |
| 👏 | 242 | |
| 👍 | 86 | 12.0% |
| 😍 | 76 | 10.6% |
| ° | 34 | 4.7% |
| 😡 | 24 | 3.3% |
| 😉 | 23 | 3.2% |
| 😘 | 20 | 2.8% |
| 😆 | 19 | 2.6% |
| 👎 | 15 | 2.1% |
| 😁 | 13 | 1.8% |
| Other values (57) | 166 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 357423 | |
| e | 348604 | |
| a | 287966 | |
| r | 204653 | 7.5% |
| i | 167459 | 6.1% |
| t | 164244 | 6.0% |
| d | 153473 | 5.6% |
| n | 141236 | 5.2% |
| s | 136679 | 5.0% |
| m | 131074 | 4.8% |
| Other values (40) | 647867 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 20985 | |
| O | 19705 | |
| A | 18252 | |
| P | 12919 | 7.3% |
| R | 12763 | 7.2% |
| C | 10218 | 5.8% |
| N | 10187 | 5.8% |
| M | 9741 | 5.5% |
| S | 8676 | 4.9% |
| T | 8257 | 4.7% |
| Other values (31) | 44700 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 51762 | |
| , | 28993 | |
| ! | 12925 | 13.1% |
| / | 1921 | 1.9% |
| ? | 1653 | 1.7% |
| " | 434 | 0.4% |
| : | 385 | 0.4% |
| ; | 226 | 0.2% |
| % | 196 | 0.2% |
| * | 82 | 0.1% |
| Other values (6) | 88 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5665 | |
| 1 | 5482 | |
| 2 | 4706 | |
| 3 | 2532 | |
| 4 | 1701 | 6.6% |
| 5 | 1569 | 6.1% |
| 6 | 1227 | 4.7% |
| 8 | 1202 | 4.6% |
| 7 | 1035 | 4.0% |
| 9 | 779 | 3.0% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 90 | |
| = | 32 | 20.3% |
| | | 12 | 7.6% |
| < | 10 | 6.3% |
| ~ | 9 | 5.7% |
| × | 2 | 1.3% |
| > | 2 | 1.3% |
| ÷ | 1 | 0.6% |
Modifier Symbol
| Value | Count | Frequency (%) |
| 🏻 | 34 | |
| ´ | 26 | |
| 🏼 | 15 | |
| 🏽 | 13 | 12.7% |
| ^ | 8 | 7.8% |
| 🏾 | 4 | 3.9% |
| ` | 2 | 2.0% |
Control
| Value | Count | Frequency (%) |
| 7277 | ||
| 7271 | ||
| 21 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 762 | |
| [ | 6 | 0.8% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 781 | |
| ] | 3 | 0.4% |
Other Letter
| Value | Count | Frequency (%) |
| º | 31 | |
| ª | 21 |
Space Separator
| Value | Count | Frequency (%) |
| 576384 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1207 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 14 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 87 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2917133 | |
| Common | 719354 | 19.8% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 576384 | ||
| . | 51762 | 7.2% |
| , | 28993 | 4.0% |
| ! | 12925 | 1.8% |
| 7277 | 1.0% | |
| 7271 | 1.0% | |
| 0 | 5665 | 0.8% |
| 1 | 5482 | 0.8% |
| 2 | 4706 | 0.7% |
| 3 | 2532 | 0.4% |
| Other values (109) | 16357 | 2.3% |
Latin
| Value | Count | Frequency (%) |
| o | 357423 | |
| e | 348604 | |
| a | 287966 | 9.9% |
| r | 204653 | 7.0% |
| i | 167459 | 5.7% |
| t | 164244 | 5.6% |
| d | 153473 | 5.3% |
| n | 141236 | 4.8% |
| s | 136679 | 4.7% |
| m | 131074 | 4.5% |
| Other values (83) | 824322 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3570160 | |
| Latin 1 Sup | 65570 | 1.8% |
| None | 491 | < 0.1% |
| Emoticons | 259 | < 0.1% |
| Latin Ext A | 7 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 576384 | ||
| o | 357423 | 10.0% |
| e | 348604 | 9.8% |
| a | 287966 | 8.1% |
| r | 204653 | 5.7% |
| i | 167459 | 4.7% |
| t | 164244 | 4.6% |
| d | 153473 | 4.3% |
| n | 141236 | 4.0% |
| s | 136679 | 3.8% |
| Other values (86) | 1032039 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| ã | 19563 | |
| é | 11815 | |
| á | 9368 | |
| ç | 8039 | |
| ó | 6440 | 9.8% |
| ê | 2027 | 3.1% |
| í | 1812 | 2.8% |
| Ó | 1569 | 2.4% |
| ú | 954 | 1.5% |
| õ | 945 | 1.4% |
| Other values (33) | 3038 | 4.6% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 76 | |
| 😡 | 24 | 9.3% |
| 😉 | 23 | 8.9% |
| 😘 | 20 | 7.7% |
| 😆 | 19 | 7.3% |
| 😁 | 13 | 5.0% |
| 😊 | 12 | 4.6% |
| 😀 | 8 | 3.1% |
| 😩 | 7 | 2.7% |
| 😃 | 6 | 2.3% |
| Other values (22) | 51 |
None
| Value | Count | Frequency (%) |
| 👏 | 242 | |
| 👍 | 86 | 17.5% |
| 🏻 | 34 | 6.9% |
| 👎 | 15 | 3.1% |
| 🏼 | 15 | 3.1% |
| 🏽 | 13 | 2.6% |
| 💓 | 11 | 2.2% |
| 🔝 | 9 | 1.8% |
| 🤗 | 8 | 1.6% |
| 🌟 | 5 | 1.0% |
| Other values (28) | 53 | 10.8% |
Latin Ext A
| Value | Count | Frequency (%) |
| ă | 5 | |
| ķ | 1 | 14.3% |
| ő | 1 | 14.3% |
| Distinct | 633 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017-12-19 00:00:00 | 546 |
|---|---|
| 2018-05-22 00:00:00 | 523 |
| 2018-05-15 00:00:00 | 522 |
| 2017-12-20 00:00:00 | 517 |
| 2018-05-04 00:00:00 | 510 |
| Other values (628) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247985 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-09-21 00:00:00 |
|---|---|
| 2nd row | 2017-07-14 00:00:00 |
| 3rd row | 2018-06-05 00:00:00 |
| 4th row | 2017-08-10 00:00:00 |
| 5th row | 2017-08-25 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-19 00:00:00 | 546 | 0.5% |
| 2018-05-22 00:00:00 | 523 | 0.4% |
| 2018-05-15 00:00:00 | 522 | 0.4% |
| 2017-12-20 00:00:00 | 517 | 0.4% |
| 2018-05-04 00:00:00 | 510 | 0.4% |
| 2018-05-19 00:00:00 | 509 | 0.4% |
| 2018-08-28 00:00:00 | 505 | 0.4% |
| 2018-03-29 00:00:00 | 504 | 0.4% |
| 2018-04-12 00:00:00 | 487 | 0.4% |
| 2017-12-13 00:00:00 | 486 | 0.4% |
| Other values (623) | 113206 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 118219 | |
| 2017-12-19 | 546 | 0.2% |
| 2018-05-22 | 523 | 0.2% |
| 2018-05-15 | 522 | 0.2% |
| 2017-12-20 | 517 | 0.2% |
| 2018-05-04 | 510 | 0.2% |
| 2018-05-19 | 509 | 0.2% |
| 2018-08-28 | 505 | 0.2% |
| 2018-03-29 | 504 | 0.2% |
| 2018-04-12 | 487 | 0.2% |
| Other values (625) | 113788 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 975204 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 205338 | 9.1% |
| 2 | 189022 | 8.4% |
| 118315 | 5.3% | |
| 8 | 94573 | 4.2% |
| 7 | 74311 | 3.3% |
| 3 | 29091 | 1.3% |
| 5 | 25342 | 1.1% |
| Other values (3) | 63529 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656410 | |
| Dash Punctuation | 236630 | 10.5% |
| Other Punctuation | 236630 | 10.5% |
| Space Separator | 118315 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 975204 | |
| 1 | 205338 | 12.4% |
| 2 | 189022 | 11.4% |
| 8 | 94573 | 5.7% |
| 7 | 74311 | 4.5% |
| 3 | 29091 | 1.8% |
| 5 | 25342 | 1.5% |
| 4 | 23775 | 1.4% |
| 6 | 23455 | 1.4% |
| 9 | 16299 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236630 |
Space Separator
| Value | Count | Frequency (%) |
| 118315 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247985 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 975204 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 205338 | 9.1% |
| 2 | 189022 | 8.4% |
| 118315 | 5.3% | |
| 8 | 94573 | 4.2% |
| 7 | 74311 | 3.3% |
| 3 | 29091 | 1.3% |
| 5 | 25342 | 1.1% |
| Other values (3) | 63529 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 975204 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 205338 | 9.1% |
| 2 | 189022 | 8.4% |
| 118315 | 5.3% | |
| 8 | 94573 | 4.2% |
| 7 | 74311 | 3.3% |
| 3 | 29091 | 1.3% |
| 5 | 25342 | 1.1% |
| Other values (3) | 63529 | 2.8% |
| Distinct | 98290 |
|---|---|
| Distinct (%) | 83.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017-08-17 22:17:55 | 63 |
|---|---|
| 2017-10-19 21:08:44 | 38 |
| 2017-05-24 16:21:27 | 29 |
| 2017-06-28 18:49:50 | 26 |
| 2017-03-23 08:34:13 | 24 |
| Other values (98285) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247985 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85104 ? |
|---|---|
| Unique (%) | 71.9% |
Sample
| 1st row | 2017-09-22 10:57:03 |
|---|---|
| 2nd row | 2017-07-17 12:50:07 |
| 3rd row | 2018-06-06 21:41:12 |
| 4th row | 2017-08-13 03:35:17 |
| 5th row | 2017-08-28 00:51:18 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-17 22:17:55 | 63 | 0.1% |
| 2017-10-19 21:08:44 | 38 | < 0.1% |
| 2017-05-24 16:21:27 | 29 | < 0.1% |
| 2017-06-28 18:49:50 | 26 | < 0.1% |
| 2017-03-23 08:34:13 | 24 | < 0.1% |
| 2017-08-01 13:20:31 | 24 | < 0.1% |
| 2018-06-04 19:04:20 | 24 | < 0.1% |
| 2018-03-07 15:08:10 | 24 | < 0.1% |
| 2017-12-22 20:33:52 | 22 | < 0.1% |
| 2017-07-30 14:19:07 | 21 | < 0.1% |
| Other values (98280) | 118020 |
Length
| Value | Count | Frequency (%) |
| 2018-05-20 | 783 | 0.3% |
| 2018-05-21 | 691 | 0.3% |
| 2018-05-10 | 593 | 0.3% |
| 2017-12-20 | 477 | 0.2% |
| 2018-04-13 | 432 | 0.2% |
| 2017-12-13 | 426 | 0.2% |
| 2018-05-11 | 424 | 0.2% |
| 2017-12-22 | 417 | 0.2% |
| 2018-08-24 | 416 | 0.2% |
| 2017-12-21 | 411 | 0.2% |
| Other values (53976) | 231560 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 378646 | |
| 1 | 350776 | |
| 2 | 299861 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 124472 | 5.5% |
| 118315 | 5.3% | |
| 3 | 109946 | 4.9% |
| 7 | 102187 | 4.5% |
| 5 | 93806 | 4.2% |
| Other values (3) | 196716 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656410 | |
| Dash Punctuation | 236630 | 10.5% |
| Other Punctuation | 236630 | 10.5% |
| Space Separator | 118315 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 378646 | |
| 1 | 350776 | |
| 2 | 299861 | |
| 8 | 124472 | 7.5% |
| 3 | 109946 | 6.6% |
| 7 | 102187 | 6.2% |
| 5 | 93806 | 5.7% |
| 4 | 93541 | 5.6% |
| 6 | 53422 | 3.2% |
| 9 | 49753 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236630 |
Space Separator
| Value | Count | Frequency (%) |
| 118315 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247985 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 378646 | |
| 1 | 350776 | |
| 2 | 299861 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 124472 | 5.5% |
| 118315 | 5.3% | |
| 3 | 109946 | 4.9% |
| 7 | 102187 | 4.5% |
| 5 | 93806 | 4.2% |
| Other values (3) | 196716 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 378646 | |
| 1 | 350776 | |
| 2 | 299861 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 124472 | 5.5% |
| 118315 | 5.3% | |
| 3 | 109946 | 4.9% |
| 7 | 102187 | 4.5% |
| 5 | 93806 | 4.2% |
| Other values (3) | 196716 |
| Distinct | 98665 |
|---|---|
| Distinct (%) | 83.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| 270c23a11d024a44c896d1894b261a83 | 63 |
|---|---|
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 |
| Other values (98660) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85739 ? |
|---|---|
| Unique (%) | 72.5% |
Sample
| 1st row | 3ce436f183e68e07877b285a838db11a |
|---|---|
| 2nd row | e6eecc5a77de221464d1c4eaff0a9b64 |
| 3rd row | 4ef55bf80f711b372afebcb7c715344a |
| 4th row | 30407a72ad8b3f4df4d15369126b20c9 |
| 5th row | 91a792fef70ecd8cc69d3c7feb3d12da |
Common Values
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| Other values (98655) | 118017 |
Length
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| Other values (98655) | 118017 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 237304 | 6.3% |
| 2 | 237291 | 6.3% |
| 5 | 237079 | 6.3% |
| c | 236988 | 6.3% |
| 6 | 236914 | 6.3% |
| 1 | 236844 | 6.3% |
| 8 | 236669 | 6.3% |
| d | 236622 | 6.2% |
| e | 236620 | 6.2% |
| 7 | 236602 | 6.2% |
| Other values (6) | 1417147 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2365456 | |
| Lowercase Letter | 1420624 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 237291 | |
| 5 | 237079 | |
| 6 | 236914 | |
| 1 | 236844 | |
| 8 | 236669 | |
| 7 | 236602 | |
| 3 | 236519 | |
| 9 | 236477 | |
| 4 | 235653 | |
| 0 | 235408 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 237304 | |
| c | 236988 | |
| d | 236622 | |
| e | 236620 | |
| a | 236602 | |
| b | 236488 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2365456 | |
| Latin | 1420624 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 237291 | |
| 5 | 237079 | |
| 6 | 236914 | |
| 1 | 236844 | |
| 8 | 236669 | |
| 7 | 236602 | |
| 3 | 236519 | |
| 9 | 236477 | |
| 4 | 235653 | |
| 0 | 235408 |
Latin
| Value | Count | Frequency (%) |
| f | 237304 | |
| c | 236988 | |
| d | 236622 | |
| e | 236620 | |
| a | 236602 | |
| b | 236488 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| f | 237304 | 6.3% |
| 2 | 237291 | 6.3% |
| 5 | 237079 | 6.3% |
| c | 236988 | 6.3% |
| 6 | 236914 | 6.3% |
| 1 | 236844 | 6.3% |
| 8 | 236669 | 6.3% |
| d | 236622 | 6.2% |
| e | 236620 | 6.2% |
| 7 | 236602 | 6.2% |
| Other values (6) | 1417147 |
order_status
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.3 MiB |
| delivered | |
|---|---|
| shipped | 1255 |
| canceled | 570 |
| invoiced | 376 |
| processing | 376 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.97406077 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1061766 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 115728 | |
| shipped | 1255 | 1.1% |
| canceled | 570 | 0.5% |
| invoiced | 376 | 0.3% |
| processing | 376 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| delivered | 115728 | |
| shipped | 1255 | 1.1% |
| canceled | 570 | 0.5% |
| invoiced | 376 | 0.3% |
| processing | 376 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 350341 | |
| d | 233660 | |
| i | 118118 | 11.1% |
| l | 116312 | 11.0% |
| v | 116114 | 10.9% |
| r | 116107 | 10.9% |
| p | 2892 | 0.3% |
| s | 2007 | 0.2% |
| c | 1892 | 0.2% |
| n | 1329 | 0.1% |
| Other values (6) | 2994 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1061766 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 350341 | |
| d | 233660 | |
| i | 118118 | 11.1% |
| l | 116312 | 11.0% |
| v | 116114 | 10.9% |
| r | 116107 | 10.9% |
| p | 2892 | 0.3% |
| s | 2007 | 0.2% |
| c | 1892 | 0.2% |
| n | 1329 | 0.1% |
| Other values (6) | 2994 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1061766 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 350341 | |
| d | 233660 | |
| i | 118118 | 11.1% |
| l | 116312 | 11.0% |
| v | 116114 | 10.9% |
| r | 116107 | 10.9% |
| p | 2892 | 0.3% |
| s | 2007 | 0.2% |
| c | 1892 | 0.2% |
| n | 1329 | 0.1% |
| Other values (6) | 2994 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1061766 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 350341 | |
| d | 233660 | |
| i | 118118 | 11.1% |
| l | 116312 | 11.0% |
| v | 116114 | 10.9% |
| r | 116107 | 10.9% |
| p | 2892 | 0.3% |
| s | 2007 | 0.2% |
| c | 1892 | 0.2% |
| n | 1329 | 0.1% |
| Other values (6) | 2994 | 0.3% |
| Distinct | 98111 |
|---|---|
| Distinct (%) | 82.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017-08-08 20:26:31 | 63 |
|---|---|
| 2017-09-23 14:56:45 | 38 |
| 2017-04-20 12:45:34 | 29 |
| 2017-06-07 12:05:10 | 26 |
| 2018-02-14 16:34:27 | 24 |
| Other values (98106) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247985 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 84913 ? |
|---|---|
| Unique (%) | 71.8% |
Sample
| 1st row | 2017-09-13 08:59:02 |
|---|---|
| 2nd row | 2017-06-28 11:52:20 |
| 3rd row | 2018-05-18 10:25:53 |
| 4th row | 2017-08-01 18:38:42 |
| 5th row | 2017-08-10 21:48:40 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:26:31 | 63 | 0.1% |
| 2017-09-23 14:56:45 | 38 | < 0.1% |
| 2017-04-20 12:45:34 | 29 | < 0.1% |
| 2017-06-07 12:05:10 | 26 | < 0.1% |
| 2018-02-14 16:34:27 | 24 | < 0.1% |
| 2018-05-12 12:28:58 | 24 | < 0.1% |
| 2017-07-07 14:55:43 | 24 | < 0.1% |
| 2017-11-25 13:54:39 | 24 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2017-10-17 13:06:29 | 22 | < 0.1% |
| Other values (98101) | 118017 |
Length
| Value | Count | Frequency (%) |
| 2017-11-24 | 1425 | 0.6% |
| 2017-11-25 | 639 | 0.3% |
| 2017-11-27 | 504 | 0.2% |
| 2017-11-26 | 482 | 0.2% |
| 2017-11-28 | 449 | 0.2% |
| 2018-08-06 | 445 | 0.2% |
| 2018-05-15 | 441 | 0.2% |
| 2018-08-07 | 440 | 0.2% |
| 2018-05-07 | 429 | 0.2% |
| 2018-05-14 | 425 | 0.2% |
| Other values (51248) | 230951 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 365963 | |
| 0 | 364100 | |
| 2 | 288776 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 122682 | 5.5% |
| 118315 | 5.3% | |
| 7 | 110056 | 4.9% |
| 3 | 104525 | 4.6% |
| 5 | 95595 | 4.3% |
| Other values (3) | 204713 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656410 | |
| Dash Punctuation | 236630 | 10.5% |
| Other Punctuation | 236630 | 10.5% |
| Space Separator | 118315 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 365963 | |
| 0 | 364100 | |
| 2 | 288776 | |
| 8 | 122682 | 7.4% |
| 7 | 110056 | 6.6% |
| 3 | 104525 | 6.3% |
| 5 | 95595 | 5.8% |
| 4 | 95495 | 5.8% |
| 6 | 56340 | 3.4% |
| 9 | 52878 | 3.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236630 |
Space Separator
| Value | Count | Frequency (%) |
| 118315 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247985 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 365963 | |
| 0 | 364100 | |
| 2 | 288776 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 122682 | 5.5% |
| 118315 | 5.3% | |
| 7 | 110056 | 4.9% |
| 3 | 104525 | 4.6% |
| 5 | 95595 | 4.3% |
| Other values (3) | 204713 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 365963 | |
| 0 | 364100 | |
| 2 | 288776 | |
| - | 236630 | |
| : | 236630 | |
| 8 | 122682 | 5.5% |
| 118315 | 5.3% | |
| 7 | 110056 | 4.9% |
| 3 | 104525 | 4.6% |
| 5 | 95595 | 4.3% |
| Other values (3) | 204713 |
| Distinct | 90173 |
|---|---|
| Distinct (%) | 76.2% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 9.5 MiB |
| 2017-08-08 20:43:31 | 63 |
|---|---|
| 2017-09-25 17:44:41 | 38 |
| 2017-04-22 09:10:13 | 29 |
| 2017-06-09 16:15:08 | 26 |
| 2018-05-12 15:41:58 | 24 |
| Other values (90168) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247700 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 72166 ? |
|---|---|
| Unique (%) | 61.0% |
Sample
| 1st row | 2017-09-13 09:45:35 |
|---|---|
| 2nd row | 2017-06-29 02:44:11 |
| 3rd row | 2018-05-18 12:31:43 |
| 4th row | 2017-08-01 18:55:08 |
| 5th row | 2017-08-10 22:05:11 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:43:31 | 63 | 0.1% |
| 2017-09-25 17:44:41 | 38 | < 0.1% |
| 2017-04-22 09:10:13 | 29 | < 0.1% |
| 2017-06-09 16:15:08 | 26 | < 0.1% |
| 2018-05-12 15:41:58 | 24 | < 0.1% |
| 2018-02-21 12:28:15 | 24 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2017-07-07 15:10:17 | 24 | < 0.1% |
| 2017-11-25 14:16:34 | 24 | < 0.1% |
| 2018-02-24 03:20:27 | 23 | < 0.1% |
| Other values (90163) | 118001 |
Length
| Value | Count | Frequency (%) |
| 2018-04-24 | 1163 | 0.5% |
| 2017-11-24 | 992 | 0.4% |
| 2017-11-25 | 939 | 0.4% |
| 2018-07-05 | 825 | 0.3% |
| 2017-11-28 | 602 | 0.3% |
| 2018-08-07 | 505 | 0.2% |
| 2018-05-08 | 494 | 0.2% |
| 2018-08-20 | 488 | 0.2% |
| 2018-05-01 | 487 | 0.2% |
| 2018-01-22 | 484 | 0.2% |
| Other values (42201) | 229621 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 379084 | |
| 1 | 364095 | |
| 2 | 287685 | |
| - | 236600 | |
| : | 236600 | |
| 118300 | 5.3% | |
| 8 | 116535 | 5.2% |
| 5 | 113898 | 5.1% |
| 3 | 110885 | 4.9% |
| 7 | 105027 | 4.7% |
| Other values (3) | 178991 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656200 | |
| Dash Punctuation | 236600 | 10.5% |
| Other Punctuation | 236600 | 10.5% |
| Space Separator | 118300 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 379084 | |
| 1 | 364095 | |
| 2 | 287685 | |
| 8 | 116535 | 7.0% |
| 5 | 113898 | 6.9% |
| 3 | 110885 | 6.7% |
| 7 | 105027 | 6.3% |
| 4 | 81998 | 5.0% |
| 6 | 51103 | 3.1% |
| 9 | 45890 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236600 |
Space Separator
| Value | Count | Frequency (%) |
| 118300 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247700 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 379084 | |
| 1 | 364095 | |
| 2 | 287685 | |
| - | 236600 | |
| : | 236600 | |
| 118300 | 5.3% | |
| 8 | 116535 | 5.2% |
| 5 | 113898 | 5.1% |
| 3 | 110885 | 4.9% |
| 7 | 105027 | 4.7% |
| Other values (3) | 178991 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 379084 | |
| 1 | 364095 | |
| 2 | 287685 | |
| - | 236600 | |
| : | 236600 | |
| 118300 | 5.3% | |
| 8 | 116535 | 5.2% |
| 5 | 113898 | 5.1% |
| 3 | 110885 | 4.9% |
| 7 | 105027 | 4.7% |
| Other values (3) | 178991 |
| Distinct | 81016 |
|---|---|
| Distinct (%) | 69.2% |
| Missing | 1254 |
| Missing (%) | 1.1% |
| Memory size | 9.4 MiB |
| 2017-08-10 11:58:14 | 63 |
|---|---|
| 2018-05-09 15:48:00 | 48 |
| 2017-10-02 23:47:54 | 38 |
| 2018-05-10 18:29:00 | 36 |
| 2018-05-14 14:25:00 | 32 |
| Other values (81011) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2224159 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 61374 ? |
|---|---|
| Unique (%) | 52.4% |
Sample
| 1st row | 2017-09-19 18:34:16 |
|---|---|
| 2nd row | 2017-07-05 12:00:33 |
| 3rd row | 2018-05-23 14:05:00 |
| 4th row | 2017-08-02 19:07:36 |
| 5th row | 2017-08-11 19:43:07 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-10 11:58:14 | 63 | 0.1% |
| 2018-05-09 15:48:00 | 48 | < 0.1% |
| 2017-10-02 23:47:54 | 38 | < 0.1% |
| 2018-05-10 18:29:00 | 36 | < 0.1% |
| 2018-05-14 14:25:00 | 32 | < 0.1% |
| 2018-05-04 15:46:00 | 29 | < 0.1% |
| 2017-04-24 11:31:17 | 29 | < 0.1% |
| 2018-08-08 15:01:00 | 27 | < 0.1% |
| 2017-06-16 15:50:28 | 26 | < 0.1% |
| 2018-06-13 14:13:00 | 24 | < 0.1% |
| Other values (81006) | 116709 | |
| (Missing) | 1254 | 1.1% |
Length
| Value | Count | Frequency (%) |
| 2017-11-28 | 925 | 0.4% |
| 2017-11-27 | 818 | 0.3% |
| 2017-11-29 | 706 | 0.3% |
| 2018-02-27 | 632 | 0.3% |
| 2018-03-27 | 622 | 0.3% |
| 2018-08-06 | 595 | 0.3% |
| 2017-11-30 | 584 | 0.2% |
| 2018-05-14 | 568 | 0.2% |
| 2018-08-13 | 550 | 0.2% |
| 2018-05-03 | 539 | 0.2% |
| Other values (37538) | 227583 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 405314 | |
| 1 | 346875 | |
| 2 | 275775 | |
| - | 234122 | |
| : | 234122 | |
| 8 | 123414 | 5.5% |
| 117061 | 5.3% | |
| 7 | 106645 | 4.8% |
| 3 | 98644 | 4.4% |
| 4 | 92073 | 4.1% |
| Other values (3) | 190114 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1638854 | |
| Dash Punctuation | 234122 | 10.5% |
| Other Punctuation | 234122 | 10.5% |
| Space Separator | 117061 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 405314 | |
| 1 | 346875 | |
| 2 | 275775 | |
| 8 | 123414 | 7.5% |
| 7 | 106645 | 6.5% |
| 3 | 98644 | 6.0% |
| 4 | 92073 | 5.6% |
| 5 | 89896 | 5.5% |
| 6 | 51438 | 3.1% |
| 9 | 48780 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 234122 |
Space Separator
| Value | Count | Frequency (%) |
| 117061 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 234122 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2224159 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 405314 | |
| 1 | 346875 | |
| 2 | 275775 | |
| - | 234122 | |
| : | 234122 | |
| 8 | 123414 | 5.5% |
| 117061 | 5.3% | |
| 7 | 106645 | 4.8% |
| 3 | 98644 | 4.4% |
| 4 | 92073 | 4.1% |
| Other values (3) | 190114 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2224159 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 405314 | |
| 1 | 346875 | |
| 2 | 275775 | |
| - | 234122 | |
| : | 234122 | |
| 8 | 123414 | 5.5% |
| 117061 | 5.3% | |
| 7 | 106645 | 4.8% |
| 3 | 98644 | 4.4% |
| 4 | 92073 | 4.1% |
| Other values (3) | 190114 |
| Distinct | 95663 |
|---|---|
| Distinct (%) | 82.7% |
| Missing | 2588 |
| Missing (%) | 2.2% |
| Memory size | 9.4 MiB |
| 2017-08-14 12:46:18 | 63 |
|---|---|
| 2017-10-18 22:35:50 | 38 |
| 2017-06-22 16:04:46 | 26 |
| 2018-06-01 15:18:45 | 24 |
| 2017-07-27 20:52:15 | 24 |
| Other values (95658) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2198813 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 82382 ? |
|---|---|
| Unique (%) | 71.2% |
Sample
| 1st row | 2017-09-20 23:43:48 |
|---|---|
| 2nd row | 2017-07-13 20:39:29 |
| 3rd row | 2018-06-04 18:34:26 |
| 4th row | 2017-08-09 21:26:33 |
| 5th row | 2017-08-24 20:04:21 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 12:46:18 | 63 | 0.1% |
| 2017-10-18 22:35:50 | 38 | < 0.1% |
| 2017-06-22 16:04:46 | 26 | < 0.1% |
| 2018-06-01 15:18:45 | 24 | < 0.1% |
| 2017-07-27 20:52:15 | 24 | < 0.1% |
| 2017-11-30 14:59:18 | 24 | < 0.1% |
| 2018-02-28 20:09:19 | 24 | < 0.1% |
| 2017-03-21 13:32:45 | 24 | < 0.1% |
| 2017-10-22 14:43:54 | 22 | < 0.1% |
| 2017-12-21 16:33:10 | 22 | < 0.1% |
| Other values (95653) | 115436 | |
| (Missing) | 2588 | 2.2% |
Length
| Value | Count | Frequency (%) |
| 2018-05-21 | 529 | 0.2% |
| 2018-05-14 | 528 | 0.2% |
| 2018-08-13 | 507 | 0.2% |
| 2018-05-18 | 505 | 0.2% |
| 2018-08-27 | 504 | 0.2% |
| 2018-05-03 | 501 | 0.2% |
| 2018-04-11 | 495 | 0.2% |
| 2017-12-11 | 489 | 0.2% |
| 2017-12-19 | 484 | 0.2% |
| 2018-04-30 | 482 | 0.2% |
| Other values (41733) | 226430 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 340135 | |
| 0 | 336692 | |
| 2 | 291234 | |
| - | 231454 | |
| : | 231454 | |
| 8 | 135449 | 6.2% |
| 115727 | 5.3% | |
| 7 | 107269 | 4.9% |
| 3 | 107060 | 4.9% |
| 4 | 100138 | 4.6% |
| Other values (3) | 202201 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620178 | |
| Dash Punctuation | 231454 | 10.5% |
| Other Punctuation | 231454 | 10.5% |
| Space Separator | 115727 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 340135 | |
| 0 | 336692 | |
| 2 | 291234 | |
| 8 | 135449 | 8.4% |
| 7 | 107269 | 6.6% |
| 3 | 107060 | 6.6% |
| 4 | 100138 | 6.2% |
| 5 | 93760 | 5.8% |
| 6 | 58490 | 3.6% |
| 9 | 49951 | 3.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 231454 |
Space Separator
| Value | Count | Frequency (%) |
| 115727 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 231454 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2198813 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 340135 | |
| 0 | 336692 | |
| 2 | 291234 | |
| - | 231454 | |
| : | 231454 | |
| 8 | 135449 | 6.2% |
| 115727 | 5.3% | |
| 7 | 107269 | 4.9% |
| 3 | 107060 | 4.9% |
| 4 | 100138 | 4.6% |
| Other values (3) | 202201 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2198813 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 340135 | |
| 0 | 336692 | |
| 2 | 291234 | |
| - | 231454 | |
| : | 231454 | |
| 8 | 135449 | 6.2% |
| 115727 | 5.3% | |
| 7 | 107269 | 4.9% |
| 3 | 107060 | 4.9% |
| 4 | 100138 | 4.6% |
| Other values (3) | 202201 |
| Distinct | 449 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017-12-20 00:00:00 | 656 |
|---|---|
| 2018-03-12 00:00:00 | 616 |
| 2018-03-13 00:00:00 | 614 |
| 2018-05-29 00:00:00 | 609 |
| 2018-07-16 00:00:00 | 590 |
| Other values (444) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247985 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-09-29 00:00:00 |
|---|---|
| 2nd row | 2017-07-26 00:00:00 |
| 3rd row | 2018-06-07 00:00:00 |
| 4th row | 2017-08-25 00:00:00 |
| 5th row | 2017-09-01 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-20 00:00:00 | 656 | 0.6% |
| 2018-03-12 00:00:00 | 616 | 0.5% |
| 2018-03-13 00:00:00 | 614 | 0.5% |
| 2018-05-29 00:00:00 | 609 | 0.5% |
| 2018-07-16 00:00:00 | 590 | 0.5% |
| 2018-07-05 00:00:00 | 588 | 0.5% |
| 2018-02-14 00:00:00 | 587 | 0.5% |
| 2018-05-28 00:00:00 | 583 | 0.5% |
| 2018-05-30 00:00:00 | 582 | 0.5% |
| 2017-12-19 00:00:00 | 582 | 0.5% |
| Other values (439) | 112308 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 118315 | |
| 2017-12-20 | 656 | 0.3% |
| 2018-03-12 | 616 | 0.3% |
| 2018-03-13 | 614 | 0.3% |
| 2018-05-29 | 609 | 0.3% |
| 2018-07-16 | 590 | 0.2% |
| 2018-07-05 | 588 | 0.2% |
| 2018-02-14 | 587 | 0.2% |
| 2018-05-28 | 583 | 0.2% |
| 2018-05-30 | 582 | 0.2% |
| Other values (440) | 112890 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 978611 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 202579 | 9.0% |
| 2 | 184497 | 8.2% |
| 118315 | 5.3% | |
| 8 | 97763 | 4.3% |
| 7 | 72165 | 3.2% |
| 3 | 31712 | 1.4% |
| 5 | 24344 | 1.1% |
| Other values (3) | 64739 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656410 | |
| Dash Punctuation | 236630 | 10.5% |
| Other Punctuation | 236630 | 10.5% |
| Space Separator | 118315 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 978611 | |
| 1 | 202579 | 12.2% |
| 2 | 184497 | 11.1% |
| 8 | 97763 | 5.9% |
| 7 | 72165 | 4.4% |
| 3 | 31712 | 1.9% |
| 5 | 24344 | 1.5% |
| 6 | 23060 | 1.4% |
| 4 | 22101 | 1.3% |
| 9 | 19578 | 1.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236630 |
Space Separator
| Value | Count | Frequency (%) |
| 118315 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247985 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 978611 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 202579 | 9.0% |
| 2 | 184497 | 8.2% |
| 118315 | 5.3% | |
| 8 | 97763 | 4.3% |
| 7 | 72165 | 3.2% |
| 3 | 31712 | 1.4% |
| 5 | 24344 | 1.1% |
| Other values (3) | 64739 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 978611 | |
| - | 236630 | 10.5% |
| : | 236630 | 10.5% |
| 1 | 202579 | 9.0% |
| 2 | 184497 | 8.2% |
| 118315 | 5.3% | |
| 8 | 97763 | 4.3% |
| 7 | 72165 | 3.2% |
| 3 | 31712 | 1.4% |
| 5 | 24344 | 1.1% |
| Other values (3) | 64739 | 2.9% |
| Distinct | 95419 |
|---|---|
| Distinct (%) | 80.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 |
|---|---|
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 |
| f9ae226291893fda10af7965268fb7f6 | 35 |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 |
| Other values (95414) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3786080 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 81018 ? |
|---|---|
| Unique (%) | 68.5% |
Sample
| 1st row | 871766c5855e863f6eccc05f988b23cb |
|---|---|
| 2nd row | 0fb8e3eab2d3e79d92bb3fffbb97f188 |
| 3rd row | 3419052c8c6b45daf79c1e426f9e9bcb |
| 4th row | e7c828d22c0682c1565252deefbe334d |
| 5th row | 0bb98ba72dcc08e95f9d8cc434e9a2cc |
Common Values
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 1d2435aa3b858d45c707c9fc25e18779 | 24 | < 0.1% |
| Other values (95409) | 117992 |
Length
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 1d2435aa3b858d45c707c9fc25e18779 | 24 | < 0.1% |
| Other values (95409) | 117992 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 237656 | 6.3% |
| b | 237239 | 6.3% |
| 1 | 237104 | 6.3% |
| a | 236995 | 6.3% |
| d | 236943 | 6.3% |
| 8 | 236741 | 6.3% |
| 3 | 236718 | 6.3% |
| e | 236647 | 6.3% |
| 5 | 236552 | 6.2% |
| 2 | 236547 | 6.2% |
| Other values (6) | 1416938 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2365944 | |
| Lowercase Letter | 1420136 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 237656 | |
| 1 | 237104 | |
| 8 | 236741 | |
| 3 | 236718 | |
| 5 | 236552 | |
| 2 | 236547 | |
| 9 | 236461 | |
| 7 | 236364 | |
| 0 | 236193 | |
| 4 | 235608 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 237239 | |
| a | 236995 | |
| d | 236943 | |
| e | 236647 | |
| f | 236430 | |
| c | 235882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2365944 | |
| Latin | 1420136 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 237656 | |
| 1 | 237104 | |
| 8 | 236741 | |
| 3 | 236718 | |
| 5 | 236552 | |
| 2 | 236547 | |
| 9 | 236461 | |
| 7 | 236364 | |
| 0 | 236193 | |
| 4 | 235608 |
Latin
| Value | Count | Frequency (%) |
| b | 237239 | |
| a | 236995 | |
| d | 236943 | |
| e | 236647 | |
| f | 236430 | |
| c | 235882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3786080 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 237656 | 6.3% |
| b | 237239 | 6.3% |
| 1 | 237104 | 6.3% |
| a | 236995 | 6.3% |
| d | 236943 | 6.3% |
| 8 | 236741 | 6.3% |
| 3 | 236718 | 6.3% |
| e | 236647 | 6.3% |
| 5 | 236552 | 6.2% |
| 2 | 236547 | 6.2% |
| Other values (6) | 1416938 |
| Distinct | 14976 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35051.68158 |
| Minimum | 1003 |
|---|---|
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3277.7 |
| Q1 | 11310 |
| median | 24310 |
| Q3 | 58640 |
| 95-th percentile | 90582 |
| Maximum | 99990 |
| Range | 98987 |
| Interquartile range (IQR) | 47330 |
Descriptive statistics
| Standard deviation | 29824.81122 |
|---|---|
| Coefficient of variation (CV) | 0.8508810385 |
| Kurtosis | -0.7823870696 |
| Mean | 35051.68158 |
| Median Absolute Deviation (MAD) | 16300 |
| Skewness | 0.7845220785 |
| Sum | 4147139706 |
| Variance | 889519364.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 161 | 0.1% |
| 22790 | 155 | 0.1% |
| 22793 | 154 | 0.1% |
| 24230 | 141 | 0.1% |
| 22775 | 128 | 0.1% |
| 35162 | 125 | 0.1% |
| 29101 | 119 | 0.1% |
| 11740 | 110 | 0.1% |
| 13087 | 108 | 0.1% |
| 36570 | 105 | 0.1% |
| Other values (14966) | 117009 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 4 | |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99990 | 1 | < 0.1% |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| Distinct | 4110 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| sao paulo | |
|---|---|
| rio de janeiro | 8261 |
| belo horizonte | 3274 |
| brasilia | 2484 |
| curitiba | 1816 |
| Other values (4105) |
Length
| Max length | 32 |
|---|---|
| Median length | 9 |
| Mean length | 10.33405739 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1222674 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1033 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | campos dos goytacazes |
|---|---|
| 2nd row | jatai |
| 3rd row | belo horizonte |
| 4th row | sao jose dos pinhais |
| 5th row | conselheiro lafaiete |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 18728 | 15.8% |
| rio de janeiro | 8261 | 7.0% |
| belo horizonte | 3274 | 2.8% |
| brasilia | 2484 | 2.1% |
| curitiba | 1816 | 1.5% |
| campinas | 1743 | 1.5% |
| porto alegre | 1667 | 1.4% |
| salvador | 1537 | 1.3% |
| guarulhos | 1404 | 1.2% |
| sao bernardo do campo | 1121 | 0.9% |
| Other values (4100) | 76280 |
Length
| Value | Count | Frequency (%) |
| sao | 25233 | 12.2% |
| paulo | 18809 | 9.1% |
| de | 11584 | 5.6% |
| rio | 9906 | 4.8% |
| janeiro | 8261 | 4.0% |
| do | 5067 | 2.4% |
| belo | 3348 | 1.6% |
| horizonte | 3302 | 1.6% |
| brasilia | 2494 | 1.2% |
| porto | 1984 | 1.0% |
| Other values (3280) | 117509 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 201636 | |
| o | 150915 | |
| i | 93525 | 7.6% |
| r | 90617 | 7.4% |
| 89182 | 7.3% | |
| e | 79407 | 6.5% |
| s | 74861 | 6.1% |
| n | 54198 | 4.4% |
| u | 53650 | 4.4% |
| l | 53296 | 4.4% |
| Other values (21) | 281387 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1132940 | |
| Space Separator | 89182 | 7.3% |
| Dash Punctuation | 288 | < 0.1% |
| Other Punctuation | 262 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 201636 | |
| o | 150915 | |
| i | 93525 | 8.3% |
| r | 90617 | 8.0% |
| e | 79407 | 7.0% |
| s | 74861 | 6.6% |
| n | 54198 | 4.8% |
| u | 53650 | 4.7% |
| l | 53296 | 4.7% |
| p | 44441 | 3.9% |
| Other values (16) | 236394 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 89182 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 262 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 288 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1132940 | |
| Common | 89734 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 201636 | |
| o | 150915 | |
| i | 93525 | 8.3% |
| r | 90617 | 8.0% |
| e | 79407 | 7.0% |
| s | 74861 | 6.6% |
| n | 54198 | 4.8% |
| u | 53650 | 4.7% |
| l | 53296 | 4.7% |
| p | 44441 | 3.9% |
| Other values (16) | 236394 |
Common
| Value | Count | Frequency (%) |
| 89182 | ||
| - | 288 | 0.3% |
| ' | 262 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1222674 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 201636 | |
| o | 150915 | |
| i | 93525 | 7.6% |
| r | 90617 | 7.4% |
| 89182 | 7.3% | |
| e | 79407 | 6.5% |
| s | 74861 | 6.1% |
| n | 54198 | 4.4% |
| u | 53650 | 4.4% |
| l | 53296 | 4.4% |
| Other values (21) | 281387 |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 236630 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RJ |
|---|---|
| 2nd row | GO |
| 3rd row | MG |
| 4th row | PR |
| 5th row | MG |
Common Values
| Value | Count | Frequency (%) |
| SP | 49865 | |
| RJ | 15425 | 13.0% |
| MG | 13718 | 11.6% |
| RS | 6539 | 5.5% |
| PR | 5988 | 5.1% |
| SC | 4319 | 3.7% |
| BA | 4069 | 3.4% |
| DF | 2500 | 2.1% |
| GO | 2453 | 2.1% |
| ES | 2351 | 2.0% |
| Other values (17) | 11088 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 49865 | |
| rj | 15425 | 13.0% |
| mg | 13718 | 11.6% |
| rs | 6539 | 5.5% |
| pr | 5988 | 5.1% |
| sc | 4319 | 3.7% |
| ba | 4069 | 3.4% |
| df | 2500 | 2.1% |
| go | 2453 | 2.1% |
| es | 2351 | 2.0% |
| Other values (17) | 11088 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 64327 | |
| P | 60178 | |
| R | 28913 | |
| M | 16723 | 7.1% |
| G | 16171 | 6.8% |
| J | 15425 | 6.5% |
| A | 6855 | 2.9% |
| E | 6207 | 2.6% |
| C | 5970 | 2.5% |
| B | 4709 | 2.0% |
| Other values (7) | 11152 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 236630 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 64327 | |
| P | 60178 | |
| R | 28913 | |
| M | 16723 | 7.1% |
| G | 16171 | 6.8% |
| J | 15425 | 6.5% |
| A | 6855 | 2.9% |
| E | 6207 | 2.6% |
| C | 5970 | 2.5% |
| B | 4709 | 2.0% |
| Other values (7) | 11152 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 236630 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 64327 | |
| P | 60178 | |
| R | 28913 | |
| M | 16723 | 7.1% |
| G | 16171 | 6.8% |
| J | 15425 | 6.5% |
| A | 6855 | 2.9% |
| E | 6207 | 2.6% |
| C | 5970 | 2.5% |
| B | 4709 | 2.0% |
| Other values (7) | 11152 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 236630 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 64327 | |
| P | 60178 | |
| R | 28913 | |
| M | 16723 | 7.1% |
| G | 16171 | 6.8% |
| J | 15425 | 6.5% |
| A | 6855 | 2.9% |
| E | 6207 | 2.6% |
| C | 5970 | 2.5% |
| B | 4709 | 2.0% |
| Other values (7) | 11152 | 4.7% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| order_id | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | seller_zip_code_prefix | seller_city | seller_state | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 00010242fe8c5a6d1ba2dd792cb16214 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-09-19 09:45:35 | 58.9 | 13.29 | 1 | credit_card | 2 | 72.19 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | 97ca439bc427b48bc1cd7177abe71365 | 5 | NaN | Perfeito, produto entregue antes do combinado. | 2017-09-21 00:00:00 | 2017-09-22 10:57:03 | 3ce436f183e68e07877b285a838db11a | delivered | 2017-09-13 08:59:02 | 2017-09-13 09:45:35 | 2017-09-19 18:34:16 | 2017-09-20 23:43:48 | 2017-09-29 00:00:00 | 871766c5855e863f6eccc05f988b23cb | 28013 | campos dos goytacazes | RJ |
| 1 | 130898c0987d1801452a8ed92a670612 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-07-05 02:44:11 | 55.9 | 17.96 | 1 | boleto | 1 | 73.86 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | b11cba360bbe71410c291b764753d37f | 5 | NaN | lannister como sempre, entregou certinho e dentro do prazo. recomendo muito | 2017-07-14 00:00:00 | 2017-07-17 12:50:07 | e6eecc5a77de221464d1c4eaff0a9b64 | delivered | 2017-06-28 11:52:20 | 2017-06-29 02:44:11 | 2017-07-05 12:00:33 | 2017-07-13 20:39:29 | 2017-07-26 00:00:00 | 0fb8e3eab2d3e79d92bb3fffbb97f188 | 75800 | jatai | GO |
| 2 | 532ed5e14e24ae1f0d735b91524b98b9 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2018-05-23 10:56:25 | 64.9 | 18.33 | 1 | credit_card | 2 | 83.23 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | af01c4017c5ab46df6cc810e069e654a | 4 | super recomendo | carrinho muito bonito | 2018-06-05 00:00:00 | 2018-06-06 21:41:12 | 4ef55bf80f711b372afebcb7c715344a | delivered | 2018-05-18 10:25:53 | 2018-05-18 12:31:43 | 2018-05-23 14:05:00 | 2018-06-04 18:34:26 | 2018-06-07 00:00:00 | 3419052c8c6b45daf79c1e426f9e9bcb | 30720 | belo horizonte | MG |
| 3 | 6f8c31653edb8c83e1a739408b5ff750 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-08-07 18:55:08 | 58.9 | 16.17 | 1 | credit_card | 3 | 75.07 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | 8304ff37d8b16b57086fa283fe0c44f8 | 5 | NaN | NaN | 2017-08-10 00:00:00 | 2017-08-13 03:35:17 | 30407a72ad8b3f4df4d15369126b20c9 | delivered | 2017-08-01 18:38:42 | 2017-08-01 18:55:08 | 2017-08-02 19:07:36 | 2017-08-09 21:26:33 | 2017-08-25 00:00:00 | e7c828d22c0682c1565252deefbe334d | 83070 | sao jose dos pinhais | PR |
| 4 | 7d19f4ef4d04461989632411b7e588b9 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-08-16 22:05:11 | 58.9 | 13.29 | 1 | credit_card | 4 | 72.19 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | 426f43a82185969503fb3c86241a9535 | 5 | NaN | NaN | 2017-08-25 00:00:00 | 2017-08-28 00:51:18 | 91a792fef70ecd8cc69d3c7feb3d12da | delivered | 2017-08-10 21:48:40 | 2017-08-10 22:05:11 | 2017-08-11 19:43:07 | 2017-08-24 20:04:21 | 2017-09-01 00:00:00 | 0bb98ba72dcc08e95f9d8cc434e9a2cc | 36400 | conselheiro lafaiete | MG |
| 5 | a0f9acf0b6294ed8561e32cde1a966bc | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-08-03 15:23:46 | 55.9 | 26.93 | 1 | credit_card | 1 | 82.83 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | c752337ac465a5e2fbdbedf7d79c6659 | 5 | NaN | NaN | 2017-08-27 00:00:00 | 2017-08-27 12:30:09 | 4851b3bca4a48b395dfad7aa57c3f72a | delivered | 2017-07-27 15:11:51 | 2017-07-28 15:23:46 | 2017-08-02 18:32:34 | 2017-08-31 20:19:52 | 2017-08-24 00:00:00 | 33449409b16400dbeaf886a5140bf59c | 44560 | dom macedo costa | BA |
| 6 | bbf796534aaf9c59f8da8c7982db56e0 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2018-03-26 03:28:44 | 64.9 | 38.50 | 1 | boleto | 1 | 103.40 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | b41646a4365a1411101396c097413907 | 5 | NaN | Muito bom chegou bem antes do prazo, produto de ótima qualidade meu filho amou | 2018-03-29 00:00:00 | 2018-03-30 12:41:53 | c32c207d9ebf75958011557ac1624e2f | delivered | 2018-03-18 21:00:44 | 2018-03-20 03:28:44 | 2018-03-20 18:08:45 | 2018-03-28 21:57:44 | 2018-04-12 00:00:00 | 31b9765a88ef50ccd457bb40491c4fbf | 45160 | belo campo | BA |
| 7 | c9ef97d2854afe64a3b4488bc2836af6 | 2 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-08-14 04:25:34 | 58.9 | 18.12 | 1 | boleto | 1 | 153.75 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | dbacd3ac90ace7ad49fe8b31bbad2808 | 5 | NaN | NaN | 2017-08-15 00:00:00 | 2017-08-24 19:35:04 | 0a29abf475fb8039d2775913d6f0b6f0 | delivered | 2017-08-05 16:59:05 | 2017-08-08 04:25:34 | 2017-08-10 16:40:11 | 2017-08-14 18:13:03 | 2017-09-06 00:00:00 | 840f10bde3c94907105e032d9c2fec3b | 75903 | rio verde | GO |
| 8 | c9ef97d2854afe64a3b4488bc2836af6 | 1 | 436c8d57ff8d4aa254318e9bd9b48c83 | 48436dade18ac8b2bce089ec2a041202 | 2017-08-14 04:25:34 | 58.9 | 17.83 | 1 | boleto | 1 | 153.75 | cool_stuff | 54.0 | 599.0 | 6.0 | 530.0 | 30.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | dbacd3ac90ace7ad49fe8b31bbad2808 | 5 | NaN | NaN | 2017-08-15 00:00:00 | 2017-08-24 19:35:04 | 0a29abf475fb8039d2775913d6f0b6f0 | delivered | 2017-08-05 16:59:05 | 2017-08-08 04:25:34 | 2017-08-10 16:40:11 | 2017-08-14 18:13:03 | 2017-09-06 00:00:00 | 840f10bde3c94907105e032d9c2fec3b | 75903 | rio verde | GO |
| 9 | df2d910b8b5e5f461f67043489f9569d | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 2017-06-09 14:31:21 | 55.9 | 35.71 | 2 | voucher | 1 | 20.00 | cool_stuff | 58.0 | 598.0 | 4.0 | 650.0 | 28.0 | 9.0 | 14.0 | 27277 | volta redonda | SP | 4e58c72bb0373240b2bd9bf84b493a69 | 1 | NaN | o carrinho veio com defeito. | 2017-06-27 00:00:00 | 2017-06-30 14:26:54 | 2e76c1f2a920153d79cc98b634c50942 | delivered | 2017-06-05 12:22:19 | 2017-06-05 14:31:21 | 2017-06-07 13:09:07 | 2017-06-26 13:52:03 | 2017-07-06 00:00:00 | 0efd4833752113fedce2e7250d49d5ac | 53403 | paulista | PE |
Last rows
| order_id | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | seller_zip_code_prefix | seller_city | seller_state | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118305 | fc8a4fcbc1b484046b9ff15de7c73577 | 1 | 86133a7d6682fcb51debce06e6514f93 | 101921376b577a4540dc30e9009133ca | 2017-06-26 03:55:21 | 373.00 | 21.49 | 1 | boleto | 1 | 394.49 | cool_stuff | 52.0 | 394.0 | 1.0 | 5000.0 | 40.0 | 27.0 | 37.0 | 13505 | rio claro | SP | aca2e1fcabddf4cdbfffc3e5c23abd2c | 2 | NaN | Faz mas de 25 dias uteis que fiz a compra. | 2017-07-13 00:00:00 | 2017-07-13 11:25:52 | 48ce8cdeb8bb76e0593b9fcdce0b453e | processing | 2017-05-19 16:14:42 | 2017-05-23 03:55:21 | NaN | NaN | 2017-07-07 00:00:00 | 6537286a5400c1e8bdf18907d66ff843 | 11680 | ubatuba | SP |
| 118306 | fcb25cc2887d15b5373673a0630ad13a | 1 | 47ac3d02c68a76bc97b3b305f6e1192f | 749e7cdabbaf72f16677859e27874ba5 | 2017-09-08 17:30:19 | 41.90 | 19.84 | 1 | credit_card | 3 | 61.74 | NaN | NaN | NaN | NaN | 3100.0 | 18.0 | 45.0 | 30.0 | 7122 | guarulhos | SP | 4ca5b8211a47c58979fe315c25c2f649 | 1 | NaN | NaN | 2017-09-15 00:00:00 | 2017-09-16 00:57:55 | 3379c7a16d562a9dbdf4b6a3d55754b3 | delivered | 2017-09-03 17:20:56 | 2017-09-03 17:30:19 | 2017-09-05 20:40:00 | 2017-09-14 18:13:25 | 2017-09-21 00:00:00 | 3d7180d54d1d270196e1b6a82c50ef46 | 22775 | rio de janeiro | RJ |
| 118307 | fd0342fda6ba083712b6ed0d4e6ac483 | 1 | 7683fe3e73bd7af6d0f6a6ed497cb04a | a1bea9970d8f65b240555f99c2214f7f | 2018-07-27 17:20:37 | 75.00 | 27.48 | 1 | credit_card | 5 | 102.48 | construcao_ferramentas_iluminacao | 49.0 | 527.0 | 4.0 | 1450.0 | 60.0 | 5.0 | 30.0 | 83323 | pinhais | PR | 466e4bb0496ab856c8ec1753cfc87986 | 3 | NaN | NaN | 2018-08-02 00:00:00 | 2018-08-03 09:48:59 | 1d3e643209846ffadac771cc5dc1ed4b | delivered | 2018-07-23 16:24:27 | 2018-07-23 17:21:07 | 2018-07-24 15:28:00 | 2018-08-01 23:46:21 | 2018-08-14 00:00:00 | 4f0a93edbe276308a671448764c8e1c2 | 79320 | corumba | MS |
| 118308 | fd607d0a02cb276bc764a15f80f0423f | 1 | 02ad78835ec3f72e750d1dfa6a7e11b3 | 2a73cba571d90c694b7caca072ccf6ce | 2018-08-02 02:24:15 | 171.39 | 19.35 | 1 | boleto | 1 | 381.48 | moveis_decoracao | 38.0 | 1303.0 | 2.0 | 1250.0 | 52.0 | 7.0 | 11.0 | 9560 | sao caetano do sul | SP | bb6e8f1301a860d4f8f42c1170608ead | 5 | NaN | NaN | 2018-08-17 00:00:00 | 2018-08-19 23:37:17 | fef79774a4f4ef014078bcb0b42d0cc5 | delivered | 2018-07-26 09:13:04 | 2018-07-27 02:24:15 | 2018-08-07 09:28:00 | 2018-08-16 17:12:37 | 2018-08-16 00:00:00 | c13401002a5f9b60befb4c720de50be0 | 41820 | salvador | BA |
| 118309 | fd607d0a02cb276bc764a15f80f0423f | 2 | 02ad78835ec3f72e750d1dfa6a7e11b3 | 2a73cba571d90c694b7caca072ccf6ce | 2018-08-02 02:24:15 | 171.39 | 19.35 | 1 | boleto | 1 | 381.48 | moveis_decoracao | 38.0 | 1303.0 | 2.0 | 1250.0 | 52.0 | 7.0 | 11.0 | 9560 | sao caetano do sul | SP | bb6e8f1301a860d4f8f42c1170608ead | 5 | NaN | NaN | 2018-08-17 00:00:00 | 2018-08-19 23:37:17 | fef79774a4f4ef014078bcb0b42d0cc5 | delivered | 2018-07-26 09:13:04 | 2018-07-27 02:24:15 | 2018-08-07 09:28:00 | 2018-08-16 17:12:37 | 2018-08-16 00:00:00 | c13401002a5f9b60befb4c720de50be0 | 41820 | salvador | BA |
| 118310 | fdaf98feac227eb978d8f33f36e0231d | 1 | f739e9151702508b18f796c53005e5e9 | d1aa1ec0839dcab73a6161130eb1f94a | 2017-04-27 05:10:28 | 119.90 | 16.14 | 1 | boleto | 1 | 136.04 | moveis_decoracao | 44.0 | 533.0 | 2.0 | 1000.0 | 69.0 | 11.0 | 11.0 | 80220 | curitiba | PR | fd48db39884359395ff6f18c8822aa7b | 4 | NaN | NaN | 2017-05-25 00:00:00 | 2017-05-26 11:42:36 | 81ae83ce1a10af9f93fa3512bd9713b1 | delivered | 2017-04-19 10:20:51 | 2017-04-21 05:10:28 | 2017-05-04 15:06:24 | 2017-05-24 10:52:43 | 2017-05-22 00:00:00 | 3d50a44231c2a153219cef76ee3e445d | 22793 | rio de janeiro | RJ |
| 118311 | fe68b52db13993f58175fa589125d345 | 1 | f4135cbdece8245560f7be179533797a | 3fefda3299e6dfaea3466ef346a3571a | 2017-08-17 02:55:27 | 209.00 | 16.21 | 1 | boleto | 1 | 225.21 | eletronicos | 32.0 | 1306.0 | 3.0 | 500.0 | 17.0 | 9.0 | 25.0 | 82620 | curitiba | PR | cd6f089e896732c91671704c7f51790e | 4 | NaN | NaN | 2017-08-18 00:00:00 | 2017-08-19 13:16:38 | 94203a446c1b46b5ac95b0aaf7221804 | delivered | 2017-08-11 10:15:22 | 2017-08-12 02:55:27 | 2017-08-14 22:03:19 | 2017-08-17 17:47:55 | 2017-09-04 00:00:00 | 52a953541861bbb4b79b39df24e00243 | 13485 | limeira | SP |
| 118312 | fefacc66af859508bf1a7934eab1e97f | 1 | 69c590f7ffc7bf8db97190b6cb6ed62e | 80ceebb4ee9b31afb6c6a916a574a1e2 | 2018-08-02 04:05:13 | 6729.00 | 193.21 | 1 | boleto | 1 | 6922.21 | pcs | 50.0 | 1935.0 | 4.0 | 5660.0 | 54.0 | 18.0 | 47.0 | 86026 | londrina | PR | ac0c6f54ff4bfc295468eb14f31c927f | 1 | Demora no retorno | Demora no retorno sobre o endereço de entrega | 2018-08-16 00:00:00 | 2018-08-16 14:20:01 | f48d464a0baaea338cb25f816991ab1f | delivered | 2018-07-25 18:10:17 | 2018-07-27 04:05:13 | 2018-08-03 14:42:00 | 2018-08-15 14:57:50 | 2018-08-10 00:00:00 | 459bef486812aa25204be022145caa62 | 29066 | vitoria | ES |
| 118313 | ff701a7c869ad21de22a6994237c8a00 | 1 | 5ff4076c0f01eeba4f728c9e3fa2653c | 3e35a8bb43569389d3cebef0ce820f69 | 2018-04-18 20:10:33 | 27.90 | 14.44 | 1 | credit_card | 1 | 84.68 | bebidas | 28.0 | 242.0 | 1.0 | 2000.0 | 19.0 | 38.0 | 19.0 | 3124 | sao paulo | SP | 2926f21f2f2aba2ce11d801e17eac783 | 5 | NaN | NaN | 2018-04-21 00:00:00 | 2018-04-24 14:13:18 | 8f6d16c31abb30b7b4650272cb0014a3 | delivered | 2018-04-12 19:47:40 | 2018-04-12 20:10:33 | 2018-04-18 00:41:29 | 2018-04-20 17:48:39 | 2018-04-30 00:00:00 | ddb2249e0316d365ceae561c0f011bce | 12280 | cacapava | SP |
| 118314 | ff701a7c869ad21de22a6994237c8a00 | 2 | 5ff4076c0f01eeba4f728c9e3fa2653c | 3e35a8bb43569389d3cebef0ce820f69 | 2018-04-18 20:10:33 | 27.90 | 14.44 | 1 | credit_card | 1 | 84.68 | bebidas | 28.0 | 242.0 | 1.0 | 2000.0 | 19.0 | 38.0 | 19.0 | 3124 | sao paulo | SP | 2926f21f2f2aba2ce11d801e17eac783 | 5 | NaN | NaN | 2018-04-21 00:00:00 | 2018-04-24 14:13:18 | 8f6d16c31abb30b7b4650272cb0014a3 | delivered | 2018-04-12 19:47:40 | 2018-04-12 20:10:33 | 2018-04-18 00:41:29 | 2018-04-20 17:48:39 | 2018-04-30 00:00:00 | ddb2249e0316d365ceae561c0f011bce | 12280 | cacapava | SP |